too few parameters

  • Thread starter Thread starter davant
  • Start date Start date
D

davant

CurrentDb.Execute "INSERT INTO BillingActivity ([Conferenc
ID],CCtype,Ccnumber,CCExpDate,CCName,CCBillAddress)Select [Conferenc
ID],[type of credit card],[credit card number],[expiration date],[nam
on credit card],[credit card billing address] FROM ExcelDataTable WHER
(Participant.[Conference ID])= (ExcelDataTable.[Conference id])AN
(Participant.PLastname) = (ExcelDataTable.Lastname) AN
(Participant.PFirstname) = (ExcelDataTable.Firstname) AN
(Participant.PEmailAddress) = (ExcelDataTable.Email)"

I am receiving error 3061-too few parameters...; I have checked an
rechecked the spelling and the number of my fields and can not locat
the error. Can someone help?

thank
 
The SQL String has lots of references to the Fields of Table [Participant]
but this Table is not accessed by the FROM clause of your SQL.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query error, too few parameters 0
Too Few Parameters....again 3
Run-time error 3061. Too Few Parameters. Expected 2. 2
Too few parameters. Expected 2 7
Too Few Parameters. Expected 1? 4
error 3061 with insert into sql 6
Error 3061 - too few parameters 2
"Too few parameters. Expected 8." 7

Back
Top