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.
- Right-click on the table name
- Select Export...
- From the Save as type field, select ODBC Databases
- Follow the prompts
- Select Machine Data Source
- Select iai6650 (our predefined System DSN)
- Supply the login id and password
If all goes well, it silently exports to the SQL Server database.