New db with comments importing 2 db's data

[SidCharming]

I have two Databases that user input goes into. They were created with a front end that did nothing for descriptions on the fields within the multiple tables. I want to create a 3rd db that has a table for each table in both other db's. However my tables in the 3rd db will have the correct labeling at the db level. How would I go about doing this? I expect to delete contents in 3rd db tables then populate/import them with data from db1 and db2 data only. How would I go about doing this?



Sid from Minnesota

 

[DougP]

Open a nwe Blank db
Right click on the Table area and click LINK
browse to find both dbs and the tables you need

then create a "make table" query and use the fields from one or both tables.

Then change the field name to your desired names


DougP, MCP, A+

 

[SidCharming]

Catch 22... on this is that the db1 & db2 are constantly being updated with data. I am going to be generating my reports off of db3 which brings both db1 & db2 data into one central location.


Sid from Minnesota