too few parameters

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
 
V

Van T. Dinh

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

run time error 424 0
Too Few Parameters....again 3
Run-time error 3061. Too Few Parameters. Expected 2. 2
Too Few parameters. Expected 2. (3061) - Northwind DB - Please Help 7
Too few parameters. Expected 2 6
ERROR 3061 - Too few parameters 1
too few parameters in SQL statement (expected 1) 2
Too few parameters? 11

Top