Web Development

General discussion


Access 2000/2 Import Data Files

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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by D_Gilmour_1978 In reply to Access 2000/2 Import Data ...

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

Related Discussions

Related Forums