Hi
I have a two database's (Access) with the same field's in both, wat i would like to do is trensfer the data from on to the other.
Is this posible?
Tried a search but I come up with a few thousand entries!
Thx
Printable View
Hi
I have a two database's (Access) with the same field's in both, wat i would like to do is trensfer the data from on to the other.
Is this posible?
Tried a search but I come up with a few thousand entries!
Thx
Do you want to do it as a one off, or part of a regular e.g. daily process?
It must be possible.
Most easy way is:
-Link the needed table from databaseB into databaseA.
-From there, you can make a query that does the hard job for you.
INSERT INTO [tbl_from_a] SELECT * FROM [tbl_from_b]
where tbl_from_a means the destination table, and tbl_from_b means the data that was coming from another database