Reading file in directory

[coughnut]

Hi, I need some help in what I am trying to do. I want be able to go to a directory and open every single file in that directory in order to populate a table. I was wonderring if any one new how to do this or could guide lines in doing this. I would need to do this in VBA, Thank you very much.

 

[PHV]

Have a look at the Dir function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[coughnut]

thanks a bunch. Do you know any good websites that would have good info on this function. The only ok webiste that I know is msdn. thanks once again.

 

[Zion7]

Just look it up in VBA help.
Mind you, Dir will just give the file name and extension, if you need the full path, you may have to open a filesystem object...also in Access help.

Or, do a search here...