Facebook To Your bussines: Export your tables into SQL Server Express

People want to migrate their tables from the measly MS Access to a much powerful SQL Server Express Edition.

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 “ODBC 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”
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

Sample Video of creating a table in MS SQL server

Facebook To Your bussines