Is it possible to export Access queries to the outside world auto?

[kutlesh]

We work here with alot of data and we must make sure that the data has good quality, meaning, data passes all validation rules.

We have many Access 2000 (mdb) and no Access 2017 (accdb) files with alot of queries.

Could I possibly develop a VBA script that will be able to export all queries from a given mdb/accdb file in some format to the outside world, or at least copy the query text into a text file, so that I dont do it manually?

Any ideas on this?

[jdc2000]

Possibly useful link:

https://stackoverflow.com/questions/...vba-code-files

There are a number of other links at this link that might give you some ideas on how to do what you want.