MS Access to SQL

T

topshed

Guppy
Hi,

I want to move my Access - ASP driven site to SQL and to do this I need to be able to port my access tables (8 Meg) over into an SQL format.

I can export my Access files in a dozen differant formats, but which one is best or does it matter

Second I assusme i will have to create a database in SQL and then write something to get my data imported

Trouble is all the tutorials tell me how to do it from scratch but I cannot find anything on how to import stuff from other DBMS

Any help would be great

Regards Topshed
 
If you are in Access 2000 or higher, there is an Upsizing Wizard (Tools->Database Utilites->...) It will help you to put your database into MSSQL. Or, if you have an Enterprise Manager for MS SQL, you can import from it
 
You must log in or register to reply here.
Back
Top