How to copy bulk copy MS Access queries from one database to another

  • Thread starter Thread starter Ron Carr
  • Start date Start date
R

Ron Carr

Hi,

Does anyone know how you can you bulk copy all your MS Access queries
from one database to another, without having to copy each one individually.

Any help would be appeciated.

Regards,

Ron.
 
Hi,

Does anyone know how you can you bulk copy all your MS Access queries
from one database to another, without having to copy each one individually.

Any help would be appeciated.

Regards,

Ron.
Click to expand...

Open the database into which you want to copy the queries.
Click File + Get External Data + Import.
Navigate to the database that contains your queries.
Select the ones you want.

If you also need the tables that make up the query, select and import
them at this time also. Click on Options to select whether you want
the data along with the table definitions.

Click OK.
 
Ron said:
Hi,

Does anyone know how you can you bulk copy all your MS Access queries
from one database to another, without having to copy each one individually.

Any help would be appeciated.

Regards,

Ron.
Click to expand...
Could someone provide me with an answer please.
 
Does anyone know how you can you bulk copy all your MS Access queries
Could someone provide me with an answer please.
Click to expand...

Open the database into which you want to copy the queries.
Click File - Get External Data - Import. An Import window opens.
Browse to the directory that contains the database that contains the queries
to be imported.
Open the database containing the queries.
In the Import Objects window, click the Queries tab.
The list of queries will show up in the Import Objects window
Click the Select All button on the right.
Click the OK button and all the queries will be imported.

Tom Lake
 
you can't do this on an automated basis without writing code

in an ACCESS DATA PROJECT you won't have to deal with this crap--
because all the queries live where they belong-- where the data lives
in a centralized server.

ARENT YOU SICK AND TIRED OF VERSIONING HELL?
 
Back
Top