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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…