Downloading multiple text files into a database

[hgus393]

Hi all,

I have a question that I hope someone may be able to answer. I have some 500 text files with the same data apperance (structure). I would like to put these text files into a database but without the manual transferring of the 500 text files i.e. using VBA instead. Is this possible?
Cheers
Robert

 

[namliam]

Yes it is, with a little coding

Lookup the "Dir" "do while" and "transfertext" commands in the help and see how far you get.