Import Microsoft Access (v2003) tables into SQL Server Express Edition (v2005)

Import Microsoft Access (v2003) tables into SQL Server Express Edition (v2005)
Steps are here:

• Open Microsoft SQL Server Management Studio Express
• Create a database for the import, if necessary
• Open the Microsoft Access database that will be imported into SQL
• Switch to “Tables” in Microsoft Access
• Right click on the Table to be exported
• Select “Export”
• In the ‘Save Type As…’ field select “ODB Databases()”
• Name the Table and Press “OK”
• Press the “New…” button
• Select “SQL Server” and Press “Next>”
• Enter a name for the Data Source then Press “Next>”
• Press “Finish”
• Enter a Description if necessary
• Select the SQL Server to connect to and Press “Next>”
• Select the correct Authentication settings and Press “Next>”
• Check “Change the default database to:” and Select the correct Database then Press “Next>”
• Press “Finish”
• Press “Test Data Source…” to very the information entered was correct
• If test completed successfully then Press “OK”
• Press “OK”
• In “SQL Server Login” dialog box, enter correct authentication information and Press “OK”
• Export should occur without any further dialog boxes or prompts
• Switch back to the Microsoft SQL Server Management Studio Express
• Navigate to the database, refresh the console and verify the table was created/imported

****AS IS****; Apply at your own risk.