Automate importing, exporting, or linking of data by using a macro

1. Create a macro.

   How?

2. Do one of the following:

   To import, export, or link data between the current Microsoft Access database and another database, click TransferDatabase in the action list of a blank action row.

   To import, export, or link data between the current Access database and a spreadsheet file, click TransferSpreadsheet in the action list of a blank action row.

   To import, export, or link data between the current Access database and a text file, click TransferText in the action list of a blank action row.

3. Set the action arguments.
   
   
4. Click Save to save the macro.
   
   
5. Run the macro.

   How?

For more information about the TransferDatabase action, click .

For more information about the TransferSpreadsheet action, click .

For more information about the TransferText action, click .