Monday, April 30, 2012

Import 2007 access file (.accdb) to SQL Server

Download below system driver and install it.
http://www.microsoft.com/en-us/download/details.aspx?id=23734
After installing you will see another Data Source option: “Microsoft Office 12.0 Access Database Engine.”

Select this option to import from an ACCDB file. Then click the Properties button to open the Data Link Properties window:



On the Data Link Properties page, provide the location of database in to the Data Source field, and enter the User name and password if applicable. Click on the Test Connection and make sure it succeeds.

Click OK to close the Data Link Properties sheet, and continue to the next page of the Wizard, to choose the Destination.

No comments: