updating a table thru VBA

[mays0515]

Hi All,

I am new to VBA and am workign on a small project. I want to retrieve a value from one table and insert that value in another table. As in:

SELECT id from tblList where name = 'mays';
say the value is 5

and when i get this value, i want to insert it into another table called tblId, as in:

insert into tblId (id) values('5');

Thanks,
Mays

 

[Mile-O]

Use an APPEND Query