Excel 2007 : External Data Query "Too few parameters expected 2"

[haseeb20]

hello all,

i am trying to use data sourcing in Excell 2007, im using a txt file to link the data to a certain cell. but whenever i run the query:

---- SELECT COUNT(COLUMN_NAME) FROM (SELECT DISTINCT COLUMN_NAME FROM `C:\SA1 MONITORING\OUTPUT FILES`\`NA_STUDENTS_TAKING_CPA.TXT` where COLUMN_NAME2 in ('31','32'))---

i get the following error message, "Too few parameters, Expected 2"

i tried using another text file which is similar it works perfectly fine but the one i want to use gives me this error. i have looked into the name and the column names they are okay

can anyone please help, urgent help needed. thanx

[Paul]

Hi Haseeb, welcome to the forum.

I don't use SQL commands too often, especially not in Excel, but are the apostrophes in the middle of the path supposed to be there?

...OUTPUT FILES'\'NA_STUDENTS.... ?

My thoughts would be that those are creating separate text strings, with a \ character sitting in the middle of the SQL command that it doesn't know what to do with.