Hey guys im wondering if anyone knows how to use the ODBC driver and

INSERT INTO [Sheet1$] (a,b,c,...)
VALUE ('valuea','valueb','valuec',...)

or simply: INSERT INTO [Sheet1$] VALUE ('valuea','valueb','valuec',...)

and this statement and add multiple values at the same time i get this error....
[Microsoft][ODBC Excel Driver] The INSERT INTO statement contains the following unknown field name: 'A'. Make sure you have typed the name correctly, and try the operation again....

or when i dont use the specific columns i get this error...
[Microsoft][ODBC Excel Driver] Number of query values and destination fields are not the same.

help me pls... i really dun know how to solve it the numbers are the same.. no doubt about tat...

thanks