Is PB novice, I want to consult everybody, I use the access database, because it is a stand-alone program, in order to realize the function of data export and import another machine, import, is to keep data on another machine incorporated into the current machine database, the data after the merger to summary of what, database table name and the table structure is the same, how to achieve the export import?

CodePudding user response:

These problems in familiar database connection, using DW read/write, wait after operation was basically can handle,

CodePudding user response:

Can you point in detail? Say I derived by arjun db, data import now to b.m db, both the MDB file with the same table a (id, name, age, sex) table B (id, address, company), how can the data together? Don't build DW, can finish? How to finish? thank you

CodePudding user response:

And which master instruct me?

CodePudding user response:

Two data window, A data window connection arjun db, B data window connection b.m db
A, A data window to retrieve data
2, the data window data replication of A to B data window
Three, B to regenerate the data window id (this id should be the primary key, can't repeat?)
Four, B data save data window

CodePudding user response:

An MDB has ten several tables? To build dw too tired!

CodePudding user response:

reference 5 floor ellenellen521leo reply:

an MDB has ten several tables? To build dw too tired!

Don't build a data window language sentence directly select out again insert in ah, is not as simple as
?
You are now the main problem is the primary key can't repeat, I doubt you two of the primary key in the database will occur repeatedly may
To be difficult to merge