Need code for recursive ASCII processing

[PaulRAmes]

I need to process (run some queries on) data from a series of ASCII files. I have the list of filenames to process in a table. How do I write code to select the proper database, open the table with the filenames, and loop through each name in the table until the last one, running the queries on each? I think I need code for this because my attempts to do this with queries alone has not worked. I'm new to modules, but have written VBA procedures for forms, etc. Any help will be greatly appreciated!
Thanks,
Paul

 

[Remou]

You can use Opendatabase to open a database; a recordset will allow you to loop through a table; TransferText will allow you to attach the table; and CurrentDB.Execute or CurrentDB.RunSQL or DoCmd.OpenQuery will allow you to run a query.

 

[JerryKlmns]

Opendatabase is needed if you do that from a different mdb.
CurrentDB (DAO) and CurrentProject.Connection (ADO) refer to your currently open database.