Extract queries to txt file (1 Viewer)

ill_comms

New member
Local time
Tomorrow, 00:38
Joined
Apr 17, 2008
Messages
9
Hi All,

I am trying to update queries in one mdb to another with a bulk update. In order to do this I want to extract out into a txt file all queries with the name and SQL statements.
I know SQL Server does this, is it possible in access or maybe I'll need to create a vb script, any help would be greatly appreciated!!!

Once the extraction is done then I'll do another update to drop all queries from the second mdb and replace them with the ones defined in the txt file.
 

Users who are viewing this thread

Top Bottom