Moving data from MS Access 2003 to SQL Server 2008

The Export and Import Wizard is an extremely useful tool for transferring data. In fact it is the simplest tool to copy over data from one database to another and to create data transfer packages that can be persisted. Data can be transferred between SQL Servers (between versions of SQL Servers for example) as well as between even two non-Microsoft databases. Another good reason for such a transfer (in the case of MS Access) could be to leverage the better security on the SQL Server while retaining the front end intact. Both Microsoft and proprietary data source providers are available to connect to many different database products.



This article is brought to you from Packt Publishing, the publisher of books on software



Review the following article and see how data is moved from MS Access 2003 to SQL Server 2008:
Transferring Data from MS Access 2003 to SQL Server 2008