Moving data from Access toSql Server 2000

[db2mainframer]

What is the best method and is there any prep work?

 

[nowayout]

if you are using SQL EM 2K then just do the DTS and it will be faster and easier.

 

[tlbroadbent]

Use the Upsizing Wizard in Access. Of course, which one you use will depend on the version of Access you use. Check the following resources.

How to Convert an Access Database to SQL Server

http://support.microsoft.com/default.aspx?kbid=237980

ACC2000: "Access 2000 Upsizing Tools" White Paper Available in Download Center

http://support.microsoft.com/default.aspx?kbid=241743

ACC2002: "Access 2002 Upsizing Tools" White Paper Available in Download Center

http://support.microsoft.com/default.aspx?kbid=294407

Microsoft Access and SQL Integration Resources

http://msdn.microsoft.com/library/en-us/dnacc97/html/acsqlres.asp

If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm