merging 2 access databases...how?

  ikle_pixie 11:32 21 Jan 03
Locked
  ikle_pixie 11:32 21 Jan 03

Is it possible?

  recap 13:04 21 Jan 03

Go to Access Help and type in the Answer Wizard and type in "Merge" you will see "Connect a data access page or other Web page to a database". this is the only reference I could find ikle_pixie, it might lead you down the right avenue? But hopefully somebody else may know how to do this easier?

  Peter E 14:51 21 Jan 03

It depends what exactly you mean by merge two databases. You can import a table (or query etc) from one database into another database (either just the structure or the structure and records) by opening the first database and selecting File - Get External Data - Import.

Also you can "paste append" records from one table (or query etc)to another table in the same database or in a different database (Go to the table, copy the data you want, open other table, insert cursor in correct position and select Edit - Paste Append).

As I said, it depends what exactly you wish to do.

Post back if you need more information.

Regards

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now