Transfer data from table a to b 1

[kennetha]

Hi All,

Is it possible to transfer all table data from a table to another by using DAO? All fields are the same for the two tables.

Some Vba code appriciated.

Thanks
Kenneth

 

[HarleyQuinn]

You can do this using an INSERT query.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[kennetha]

Have no idea how to INSERT query with DAO

 

[HarleyQuinn]

No problem

You can run a SQL string using

DoCmd.RunSQL()

The basic syntax for an INSERT in your situation is:

INSERT INTO Table1
SELECT Table2.*
FROM Table2;

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[kennetha]

Thanks

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.