Web Development

Ask something
Discussion Locked

Access 2000/2 Import Data Files

0 helpful
1 reply

by parli singh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

by d_gilmour_1978

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

This discussion is closed to new replies.