Table records exporting to another table.

[aligahk06]

Dear All,

Can i export one table records to another table .
These two tables are from two different Access forms.

Please help.

Rgds,
Aligahk06

[OBP]

Do you mean that you want to Add the data from one table in to another table to delete one of the tables?
As Duplicating data is not recommended.

[CreganTur]

If both tables duplicate the same data, then you have a problem with your database structure- it's neither truly relational nor normalized. You can have multiple forms feed from the same table, but you should have a query between them that controls which data from the table is displayed on the form.