Error executing SQL Command for data source

[PBREP]

Hello there:

Error Message: "Error executing SQL Command for data source Customers Connectivity error [Microsoft][ODBC Microsoft Access Driver] Too few parameters. expected 2."

First thing I done was created a new ODBC drivere = "made no difference"

using ODBC from a third party shipping program, attempting to retrieve data from an MS Access 2K database. My SQL is as followed:

SELECT Customers.BillingAddress, Customers.City, Customers.CompanyName, Customers.Country, Customers.ContactFirstName, Customers.ContactLastName, Customers.E-Mail, Customers.PhoneNumber, Customers.StateOrProvince, Customers.PostalCode, Customers.CustmerId

FROM Customers WHERE Customers.Customers.CustomerID = '!input!'

Thank You, PM

 

[pipk]

try removing one of the 'Customers' from your where clause

i.e.

FROM Customers WHERE Customers.CustomerID = '!input!'

 

[PBREP]

Sorry, "Customers.Customers.CustomerID = '!input!' " is a typo however, it is type correctly in my script, still having the same problem; any other suggetions would be greatly apreciated.

Thank you for your response.

PM