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.
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.