+ Post New Thread
Results 1 to 4 of 4
Windows Thread, Downloading SQL Database to Access in Technical; I have an SQL database on my web-server and want to be able to download it to access. How do ...
  1. #1

    Join Date
    Dec 2009
    Location
    Maidenhead
    Posts
    10
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    10

    Downloading SQL Database to Access

    I have an SQL database on my web-server and want to be able to download it to access.

    How do i do it?

    Access 2003

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,265
    Thank Post
    242
    Thanked 1,575 Times in 1,254 Posts
    Rep Power
    341
    It's a good question. Access to MSSQL is possible, but you may have to pay for something to convert MSSQL to Access.

    Alternatively use MSSQL Express which is free

  3. #3
    CSNM-Carl's Avatar
    Join Date
    Jan 2008
    Location
    Teesside
    Posts
    344
    Thank Post
    145
    Thanked 62 Times in 50 Posts
    Rep Power
    45
    Why would you want to convert a MySQL database to Access, a step backwards?

  4. #4
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    Quote Originally Posted by CSNM-Carl View Post
    Why would you want to convert a MySQL database to Access, a step backwards?
    I often convert bits of a ORACLE databases back to access, as it's interface is jsut easier to think through when doing complex reporting. Especially when DISCO hates running through multiple reports to get a combined one (last time I tried it claimed it would take 32 days to run...).

    Export it as CSV using the web interface your host should provide and then import into access.
    Last edited by mossj; 6th February 2010 at 03:44 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. vmware SQL database
    By badders in forum Thin Client and Virtual Machines
    Replies: 5
    Last Post: 29th September 2010, 02:26 PM
  2. No access to any database on SQL server
    By button_ripple in forum MIS Systems
    Replies: 2
    Last Post: 1st May 2009, 08:17 AM
  3. Restoring a SQL 2000 Database
    By Neville in forum Windows
    Replies: 0
    Last Post: 12th March 2009, 09:09 AM
  4. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 03:24 PM
  5. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •