Export a table or query to an SQL database table or other ODBC data source

Important   You cannot export a table or query to an SQL database or other ODBC data source unless you have installed the appropriate driver.

1. In the Database window, click the name of the table or query (Microsoft Access database only) you want to export, and then on the File menu, click Export.
   
   
2. In the Export Object Name 'Object name' In dialog box, in the Save As Type box, click ODBC Databases ().
   
   
3. In the Export dialog box, enter a name for the file (or use the suggested name), and then click OK.

   The Select Data Source dialog box is displayed; it lists the defined data sources for any ODBC drivers installed on your computer. Click either the File Data Source or Machine Data Source tab, and then double-click the ODBC data source that you want to export to. To define a new data source for any installed ODBC driver, click New, and then follow the instructions in the Create New Data Source dialog box and the dialog boxes that follow it before continuing. Learn about data sources.

   Particular ODBC data sources have different requirements for accessing their data. For example, most require you to enter a logon ID and password. You might need to get this information from your system administrator. Enter the appropriate information in the dialog box, and then click OK.

   Microsoft Access connects to the ODBC data source and creates the new table.

Notes

• After you export a table from a Microsoft Access database to an SQL database, you can use an SQL pass-through query to add an index to the table. For more information, click .
  
  
• If you are exporting from a Microsoft Access Project to a Microsoft SQL Server database, consider using Data Transformation Services (DTS), which can be a faster and more flexible way to export and transform data. For more information, see the Microsoft SQL Server documentation.