General discussion

  • Creator
    Topic
  • #2280144

    Access 2000/2 Import Data Files

    Locked

    by parli singh ·

    I can write a macro to import a single file from a direcotory, but having trouble writing one to import several files.
    Obj: 1) Import Files, where the file path is known, but not the number of files in the folder and the filenames dont always begin with same prefix.

All Comments

  • Author
    Replies
    • #3365468

      Reply To: Access 2000/2 Import Data Files

      by d_gilmour_1978 ·

      In reply to Access 2000/2 Import Data Files

      Use the file system object and then loop through the files then use your existing code to import them inside the loop. It has been awhile so I can’t remember the syntax off-hand but it shouldn’t he hard to find the documentation needed

Viewing 0 reply threads