I want a way to retrieve a list of all the files in a chosen directory or folder.
Pretty much any format will do, although something like an array of filenames and metadata such as dates would probably be the best.
The overall goal will be to generate a list of .sql files in \\server\folder\ and read the contents of each file so they can be executed against a database.
Using a Windows API call or whatever is fine. I am using Windows 2000.
Thank you for your time.