MS SQL Data Warehousing - Access Table conversion

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Access Table conversion

mike

2005-07-30, 11:23 am

how difficult is it to convert access tables to SQL that can continue to be
linked to an Access GUI.

Peter Nolan

2005-08-01, 7:23 am

Mike,
trivial....there is an Access Upsizing tool in Access that will convert
the data to MS SQL and then you can change your app to read these
tables via ODBC. If you have hard coded access to the tables in your
access app you need to change them to recordsets accessed via
ODBC....that's about it....when we did this on a small system many
years ago we got it done by a fresh uni grad and he only took a couple
of days.....

Peter

Sponsored Links