Importing Information from a Delimited Text File To import an Excel worksheet into an existing table
On the File menu, point to Get External Data, and then click Import.
In the Files of type list, click Microsoft Excel.
Navigate to the folder that contains the worksheet, click the file, and then click Import.
Follow the instructions on the Import Excel Worksheet Wizard, and then click Finish to complete the process.
Importing Information from a Delimited Text File To import information from a text file into an existing table
On the File menu, point to Get External Data, and then click Import.
In the Files of type list, click Text Files.
Navigate to the folder that contains the information, click the file, and then click Import.
Follow the instructions on the Import Text File Wizard, and then click Finish on the wizard’s last page to import the text file into the appropriate location, and then click OK to close the message box.
Importing Information from an Access Database To import information from an Access database
On the File menu, point to Get External Data, and then click Import.
In the Files of type list, make sure Microsoft Access is selected.
Navigate to the folder that contains the database, click the file, and then click Import.
Click the Options button to select any import options you want.
Select the objects you want to import, or click Select All to import all objects, and then click OK.
Importing Information from Other Databases To import information from another database
On the File menu, point to Get External Data, and then click Import to open the Import dialog box.
In the Files of type list, click the database type you want to import.
Navigate to the folder that contains the database, click the file, and then click Import.
Follow the wizard’s instructions, and click Finish to complete the process, and then click OK.
Importing Information from an HTML File To import information from an HTML file into an existing table
On the File menu, point to Get External Data, and then click Import.
In the Files of type list, click HTML Documents.
Navigate to the folder that contains the HTML file, click the file, and then click Import.
Follow the instructions on the Import HTML File Wizard, click Finish to complete the process, and then click OK.
Importing Information from an XML File To import information from an XML file into an existing table
On the File menu, point to Get External Data, and then click Import.
In the Files of type list, click XML.
Navigate to the folder that contains the XML file, click the file, click Import, and then click the Options button to display the import options.
Click the Options button to select any import options you want, and then click OK twice.
Exporting Information to Other Programs To export information to another program
In the database window, click the table you want to export.
On the File menu, click Export to display the Export Table To dialog box.
Navigate to the folder where you want to store the exported file, select the appropriate Save as type option, type a name for the file, and then click Export.
Linking a Database to Information in Another Database To link a table in one database to another
On the File menu, point to Get External Data, and then click Link Tables.
In the Link dialog box, navigate to the folder that contains the database to which you want to link, select the appropriate Files of type setting, select the file, and then click Link.
In the Link Tables dialog box, click the name of the table that you want to link to, and then click OK.
Linking a Database to Information in Another Database To link a database to an Excel worksheet
On the File menu, point to Get External Data, and then click Link Tables.
Navigate to the folder that contains the worksheet to which you want to link. In the Files of type list, click Microsoft Excel, select the worksheet, and then click Link.
Follow the instructions of the Link Spreadsheet Wizard, click Finish, and then click OK.
Other Ways to Share Access Data To copy and paste Access data into an Excel worksheet
Open the table in Datasheet view.
Select the records you want to copy by pointing to the row selector of the first record you want to select (the pointer changes to a right arrow), holding down the left mouse button and dragging to the last record you want to select. Then on the toolbar, click the Copy button.
Start Excel, and with cell A1 of a new blank worksheet selected, click the Paste button on Excel’s toolbar.