MS Access Query to Run a macro to import text files from a folder
Posted on 2012-03-29
I have already created a query to summarize the results. However I want to use the results and import text files based on the results.
I run a query which brings me only Apples, Milk and Honey and now I need to take these results and import text files based on them in a specified folder.
i.e. Apples.txt, Milk.txt and Honey.txt
I know it requires a while loop such that Look through each members of the field until the end and for each field take the name and import the text file into a table.
Unfortunately I'm not well versed in sql to know the syntax.