Web Development·11,944 discussions

Access 2000/2 Import Data Files

Locked

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.

Topic

Reply To: Access 2000/2 Import Data Files

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

[Author]

Replies