Table to Table with VBA

[Jason]

I need transfer a table of data to another table
with the use of VBA.

For example:
Read from table 1 then
perform some computation then write to table 2.

Can someone help.

Thanks

 

[Steve Schapel]

Jason,

It sounds like an Append Query would be the way to go here. Make a
Query based on Table1, including the computatrions and any criteria
selections, make it into an Append Query (select Appand from the Query
menu), nominate Table2 as the table to append to, and in the Apend To
row of the query design grid, make sure the applicable Query2 fields are
selected. If you want to run the append query with a macro, you can do
so using the OpenQuery macro action.