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

In my little corner of the world, I have seen this issue come up three times by three different people in the past 7 days so I thought I would posts this. I actually just went through this myself a little bit ago:

1. Open Microsoft SQL Server Management Studio Express
2. Create a database for the import, if necessary
3. Open the Microsoft Access database that will be imported into SQL
4. Switch to “Tables” in Microsoft Access
5. Right click on the Table to be exported
6. Select “Export”
7. In the ‘Save Type As…’ field select “ODB Databases()”
8. Name the Table and Press “OK”
9. Press the “New…” button
10. Select “SQL Server” and Press “Next>”
11. Enter a name for the Data Source then Press “Next>”
12. Press “Finish”
13. Enter a Description if necessary
14. Select the SQL Server to connect to and Press “Next>”
15. Select the correct Authentication settings and Press “Next>”
16. Check “Change the default database to:” and Select the correct Database then Press “Next>”
17. Press “Finish”
18. Press “Test Data Source…” to very the information entered was correct
19. If test completed successfully then Press “OK”
20. Press “OK”
21. In “SQL Server Login” dialog box, enter correct authentication information and Press “OK”
22. Export should occur without any further dialog boxes or prompts
23. Switch back to the Microsoft SQL Server Management Studio Express
24. Navigate to the database, refresh the console and verify the table was created/imported