How to move tables from Access to SQL?

D

Dennis

I have some truly huge tables in an Access2002 database. I need to move these
tables to SQL on another server. The SQL space has been reserved for me.
Okay, what steps do I need to take to export the tables to the SQL server?

Thanks!
 
P

Pat Hartman

Make sure that all column and table names conform to SQL server standards.
Make sure that all tables have primary keys defined.
Remove any extraneous indexes.
Make sure that all relationships are correctly defined.
Once the tables are "perfect", just use the upsizing wizard and follow the
directions. Chose the option to link the tables to the existing db.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Adding data to MS Access from csv file 0
Move Access Table to SQL Server 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Exporting tables to .sql code 2
Conneting to SQL server, Need advice 4
Synchronization problems while moving folders to new email 1

Top