I am trying to populate an Access database using insert statements through JDBC. All the fields in the table are defined as text. If I try the statement below, I get the Too few parameters.... error.
temp: insert into bill_payment_data values(eric1,eric2,eric3,eric4,eric5,eric6,e
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 21.
However if i just try to insert 1,2,3,..21, the insert works fine. Any idea what the problem is?