sql server odbc: importing tables from Acess to SQL -- sql server odbc

importing tables from Acess to SQL

×’×œ
1/23/2005 1:29:01 AM

sql server odbc: Hello

I am trying to import tables with data from Access to SQL.
The problem occures when the Primary keys and identity are not being saved
and i need to do it manually.
There is a way to import this tables with all the connection regulations
like Primary key will be saved ?

thanks

Re: importing tables from Acess to SQL

Ragnar Midtskogen
1/31/2005 1:36:56 PM

We have found that the safest way to move from Access to SQL Server is to
convert the Access file to 2002, then use the Upsize Wizard to move the
schema only. Finally we use the Data Transformation Services of SQL Server
to import the data from Access.
Make sure that all the tables have a key index.

Ragnar

[quoted text, click to view]