You can find information about exporting data from Microsoft Access to various Web formats in Part 6, “Linking Access and the Web. ” This article provides details about exporting data to other Access databases and other file types. You can export (copy) any object in an Access database to any other Access database. You can also export data from Access tables to spreadsheet files, other databases, text files, Microsoft Word mail merge documents, and SQL tables. | Part 9 Articles Article 2 Exporting Data Exporting to Another Access Database .A45 Exporting to a Spreadsheet or to a dBASE or Paradox Quick Export to Microsoft Exporting to a Text File. A46 Exporting to a Mail Merge Document in Microsoft Word .A47 Exporting to an SQL You can find information about exporting data from Microsoft Access to various Web formats in Part 6 Linking Access and the Web. This article provides details about exporting data to other Access databases and other file types. You can export copy any object in an Access database to any other Access database. You can also export data from Access tables to spreadsheet files other databases text files Microsoft Word mail merge documents and SQL tables. Exporting to Another Access Database Exporting objects from one Access database to another works much like importing Access objects. See Chapter 6 Importing and Linking Data. To export any object from one Access database to another Access database do the following 1 Open the Access database from which you want to export an object. If that database is already open switch to the Database window. 2 Select the object you want to export in the Database window and then choose the Export command from the File menu. Access opens an Export To dialog box in which you can select the folder and the name of the Access desktop database .mdb or project file .adp to which you want to export the object. You can export queries in an Access project only to another project file. After you make these selections click Save. 3 Next Access opens the Export dialog box. Use the Export dialog box to specify a name for the object in the target database. You can keep the name that Access suggests or you can change it to make it more appropriate to the target database. Note that if you re exporting a table you can choose to export both the table definition and the data or the definition only. Click OK to export the object. 4 If the export name you type in
