Looping around files in a windows folder

[mozgheib]

Hello,

I have a windows folder with many csv files. Now I would like to import all these csv files into sql in vba apply some logic and spit out one consolidated file.

WHat I would like to know how can I write code to go into the folder and loop around all the files in order to make the file name i am importing a variable?

Please advise.
Thanks.

 

[Craig0201]

Look up the FileSystemObject and related classes in The Microsoft Scripting Runtime reference.

 

[PHV]

Or simply take a look at the VBA Dir function.

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