VBA Module to read records

[MichaelTrainor]

I have a DB that is currently using linked text files that are queried(maketable, append, and delete) to clean up some data and export per my saved specs. I want to convert as much of the processing (e.g. queries) into VBA or SQL, but I'm not sure how to go about it.

I work with multiple files in differnet locations, and would like to select the files in a file dialog box.

I would also like to be able to choose the file name in the same manner when exporting my clean data.

 

[traingamer]

See this link faq705-2484

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill