I am able to write the update...sql statement in my VBA code but i need to write insert into...statement. Can you please give me an example.It says syntax error when I use insert into. I used the RunSql method of DoCmd object.
Brain, can you please help???

Insert into table (field1, field2, ... fieldn) Select data1, data2, ... datan

Be aware that the data values must be appropriately deleniated. A string must have quotes on either end (and not anywhere in the string). A date must have the hash (#) on either end.

Tip: Use the query builder to create an Append query (same as Insert) then switch to SQL view to get the string.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Thank you soo much!
The problem was only with syntax I believe.
Thanks a lot!!!