Copy fields from one table to another table using VBA.

[littlebro]

I have an Access database that has two tables in it. The first table has three fields in it and the other has four fields. I want to get two of the fields in the first table into the other table by pushing a button.

Can anyone help me?

Thanks
lb

 

[vb5prgrmr]

[tt]
insert into table2 (field1, field2) select field1, field2 from table1
[/tt]

or something like that...

Good Luck

 

[littlebro]

Thats the SQL, but what about the VBA

 

[vb5prgrmr]

execute the sql from the vba...
[tt]
Dim adoCommandObject As ADODB.Command
Dim adoConnectionObject As ADODB.Connection
...
[/tt]

Good Luck