Automate importing, exporting, or linking of data by using Visual Basic

  1. Create a Visual Basic procedure.

    How?

  2. Do one of the following:

    To import, export, or link data between the current Microsoft Access database and another database, use the TransferDatabase method to carry out the TransferDatabase action in the procedure.

    How?

    To import, export, or link data between the current Microsoft database and a spreadsheet file, use the TransferSpreadsheet method to carry out the TransferSpreadsheet action in the procedure.

    To import, export, or link data between the current Microsoft database and a text file, use the TransferText method to carry out the TransferText action in the procedure.

  3. Run the procedure.

    How?

For more information about the TransferDatabase method, click .

For more information about the TransferSpreadsheet method, click .

For more information about the TransferText method, click .