How do I convert my database from Access to SQL Server?

Importing your database from Access to SQL Server is very similar to moving a SQL Server database from another provider.

First, please read article #420. After reviewing that KB article, you will need to create a DSN or Datasource on your local machine pointing to your local Access database.

You will use that Datasource as your source database. When prompted for the destination SQL Server Database, use the information provided in the "Website Ready" email. This can be found in the WebControlCenter as well, under Site-Overview.

For more information, please visit the following Microsoft Knowledge Base Article: http://support.microsoft.com/default.aspx/kb/237980

Add Feedback