Dear All,
Can i export one table records to another table .
These two tables are from two different Access forms.
Please help.
Rgds,
Aligahk06
Printable View
Dear All,
Can i export one table records to another table .
These two tables are from two different Access forms.
Please help.
Rgds,
Aligahk06
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.
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.