Import Specification Access vba

0
votes

I have an import specification in Access for a CSV file.

I want the user to:

  • Use the import specification
  • specify the file to import

Is there a way in VBA to somehow show the saved imports window where the user can specify a path or change this path dynamically?

1
ms-accessvba

1 Answers

0
votes

You can show a File dialog and then call the DoCmd.TransferSpreadsheet method with the user-selected file and your import specification.