How to export a report from an Access db to another Access db

[ick64]

Hello all,

I have two different/separate Access databases and I would like to export a report from one db to another as it has a very specific and detailed format.

Before moving on with the export procedure, I would like to ask you how must I consider the fields from the exporting db? Must I have them created in the importing db exactly with the same names or will Access ask for some kind of correlation among the fields from both db's?




Thank you!

[ranman256]

in a macro,
set the action COPYOBJECT
set the src db path
target db path
object type (report)
object name

run the macro.
The report will run assuming ALL fields in the same query in the target db.

[ick64]

Thanks, I will work on it!

[isladogs]

Just to suggest a much easier method.

IMPORT the report from the old database into the new database using the import wizard (External Data ... Import ... Access ...)

As Ranman said previously, the report will run as long as you have the same data source (query or table) in new database

[ick64]

Yes - so the key here will be to keep the same data source.

Thank you!!

[SierraJuliet]

Side Note:

It is worth mentioning that it is wise to export all tables, queries, forms, and reports as excel and/or text files by selecting "Export data with formatting and layout." and all Class Objects as File Class and modules as Basic Class (Alt + F11).
This will make data source duplication in the future easier as everything will be formatted the same.

[ick64]

Got it - thanks SierraJuliet!

[SierraJuliet]

You are welcome. Just be sure to do it when you are all complete with building your database but before you enter information into it so you have nice clean tables. Afterwards you can export the same stuff with your information contained therein but I would ensure both are kept separate. This is my personal preference.