Export objects in bulk?

  • Thread starter Thread starter Nathan
  • Start date Start date
N

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?
 
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.
 
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?
 
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?
Click to expand...

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.
 
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.
 
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
 
Nathan said:
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?
Click to expand...
 
Back
Top