Import Data and only Data...

[darno]

I have 2 Databases, i.e., OLD.MDB and NEW.MDB both have same table, named as TABLE A and the structure is also identical. In simple words they are true replica of each other. For testing purposes I wish to import Data and only Data from OLD.MDB table A to NEW.MDB table A. Please understand that I only want DATA not the whole table to be copied or linked. Please help me in achieving this task.

I have searched the whole forum but could not find my answer. Please provide if there is any code or macro used for this task. Your attention and help in this regard is highly appreciated.


Warm Regards,


Darno

 

[neileg]

Use the 'Get external data' option from the file menu. This will allow you to import the table from OLD to NEW. If it has the same name, the wizard will rename the imported table, TABLE_A1. Then run an append query to add the data to your existing table in NEW. Now delete the imported table.

 

[ScottGem]

I have 2 Databases, i.e., OLD.MDB and NEW.MDB both have same table, named as TABLE A and the structure is also identical. In simple words they are true replica of each other. For testing purposes I wish to import Data and only Data from OLD.MDB table A to NEW.MDB table A. Please understand that I only want DATA not the whole table to be copied or linked. Please help me in achieving this task.

I have searched the whole forum but could not find my answer. Please provide if there is any code or macro used for this task. Your attention and help in this regard is highly appreciated.

Warm Regards,

Darno

What's not clear is what you mean by DATA. It sounds like you only want some records from the Old into the New ("not the whole table"). If that's the case, then do what I suggested. Link the table and run an Append query that copies only the records you want. You can then delete the link.