best way to import data from access to Sql server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

best way to import data from access to Sql server

Hi All, I have huge amount of data with lots of contraints in Access 2000.
We are planning to move all the data in sql server 2000.
Can u tell me the best solution. thanks Shardul sshah
Best solution would be using access upgrade wizard refer
http://www.sqlservercentral.com/columnists/dasanka/upsizingtheaccessdatabaseintothesqlserver.asp
]]>