Exporting to an ODBC Database
You can export data from an Access table or query to define a new table in any database that supports the ODBC standard. To export data in an Access table or query to another database system that supports ODBC SQL, you must have the ODBC driver for that database installed on your computer. Your computer must also be linked to the network that connects to the server running Microsoft SQL server you want, and you must have an account on that server. Check with your system administrator for information about correctly connecting to the ODBC database to which you want to export data.
Note
For details about defining an ODBC data source, see Creating a Data Source to Link to an ODBC Database.
To export data to an ODBC database, ...
Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
