Exporting Access Tables to SQL Server

Presuming your tables are in Access, it is fairly simple to export them one at a time to an ODBC database server, given that you have an account and database already present on the server.

1. Right-click on the table name
2. Select Export...
3. From the Save as type field, select ODBC Databases
4. Follow the prompts
5. Select Machine Data Source
6. Select iai6650 (our predefined System DSN)
7. Supply the login id and password

   If all goes well, it silently exports to the SQL Server database.