Export objects in bulk?

[Nathan]

I have a large amount of objects (queries, forms, macros and reports) that I
want to move from one mdb to another. Is there a way I can export them in
BULK, rather than individually selecting each one?

 

[Jerry Whittle]

If you go to the other database, you can import them all pretty much in bulk.
There is a select all option.

You could also backup the current database to another DB name.

 

[Nathan]

Jerry,
The backup method won't work - they are two distinct databases already in
use for different purposes. They share many tables, which is why it makes
sense for me to move around queries, etc.

I opened the target mdb, but I don't see an "import" option. Can you give
me some guidance on where I might find the command to import?

 

[John W. Vinson]

I opened the target mdb, but I don't see an "import" option. Can you give
me some guidance on where I might find the command to import?

What version of Access? In 2003 and before, it's File... Get External Data...
Import on the menu; in 2007 and 2010 it's on the External Data tab.

 

[Jerry Whittle]

Which version of Access? 2007 and the rest are a lot different.

 

[Nathan]

Apologies. I'm using 2003.

The Import DATA isn't the right thing - it does allow me to grab forms,
reports or macros at all. As its name suggests, it just looking for data.

 

[GP George]

Yes, you CAN import the other objects from the same place. When you click on
File-->Get External Data, you should see two options. One is to "Link
tables...", the other to "Import..." That second one is the one you want to
click to get access to the forms, reports, etc. in the database from which
you plan to retrieve them.

George

 

[De Jager]

I have a large amount of objects (queries, forms, macros and reports) that
I
want to move from one mdb to another. Is there a way I can export them in
BULK, rather than individually selecting each one?