Opening Muiple Files in Sequence

  • Thread starter Thread starter Burt Rosner
  • Start date Start date
B

Burt Rosner

To Anyone That Can Help,

First off I might not be explaining what I want to do
accurately. But, here it goes.

I have 10 files in a folder,
e.g. c:\MyFolder\File1.txt, c:\MyFolder\File2.txt, etc...

I would like to import all files within that folder
without performing a File/Open command for each file.

Is there any way I can do that? If yes, please share it
with me.

Thanks,

Burt
 
If you are importing them into Access, you can cycle
through the folder, then do a TransferText on each one.
That way, you won't have to handle opening each one.

Are you importing into different tables, the same table,
what? j.
 
Jennifer,

YES.

I didn't try it yet, but I know it will work as long as I
know the names of the files I'm bring in; and I know how
to do that. I've done something similar in the past. I
just didn't think of it for this function.

Thanks for the extra set of eyes.

Also, I am bring it into MS Access.

Burt
 
Back
Top