importing query and report objects

[northstar]

I have been asked to create several reports (and supporting queries) for
importing into a database. My experience is limited to create objects within
the database. I am now asked to create these reports for importation. I would
use a copy of the database in which to create the reports. This is so data
input can continue while I work external to the original database. As I said,
I have no experience importing new reports into an existing database. To say
"yes" or "no" to the invitation is currently based on ignorance of the ease
or difficulty of the report importing process. Advice and pointers welcomed!

 

[Ken Snell MVP]

Importing objects from one database into another is very simple, especially
if the code used by the objects is fully contained within those objects.

It's done by File | Get External Data | Import menu, and you select
".mdb" as the file type. After you browse to the ACCESS file that contains
the objects you wish to import, a window will open and let you choose the
objects you want to import.

 

[northstar]

Thank you very much. I experimented with copies of the db and created several
reports, then imported them into another copy. Just as you said. Very Helpful.