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 ...
6th February 2010, 01:10 PM #1
- Rep Power
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?
6th February 2010, 01:20 PM #2
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
6th February 2010, 02:22 PM #3
Why would you want to convert a MySQL database to Access, a step backwards?
6th February 2010, 03:40 PM #4
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...).
Originally Posted by CSNM-Carl
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.
By badders in forum Thin Client and Virtual Machines
Last Post: 29th September 2010, 02:26 PM
By button_ripple in forum MIS Systems
Last Post: 1st May 2009, 08:17 AM
By Neville in forum Windows
Last Post: 12th March 2009, 09:09 AM
By Mr_M_Cox in forum MIS Systems
Last Post: 16th August 2007, 03:24 PM
Last Post: 8th June 2006, 09:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)