recordset "WHERE" failing

I am pulling information from a CSV into a recordset
I can read the csv fine to run an "open for append" sub.

Please Login or Register  to view this content.

however the second function intended to fill an array of matching parts for a revision userform is failing (Runtime error 80040e10) no value for required parameters on the recordset.open line.

Please Login or Register  to view this content.

The locals is pulling the query through fine

Source

"SELECT * FROM TestFile.csv WHERE PartNo = ACTEST"

Variant/String

Unfortunately because the process is passed to ACE, VBA isn't able to give much information on what is wrong.

If that were the issue surely it would just return an empty set rathere than throwing out a runtime error?
Added in the single quotes and the error changes to 80040e07 though...

needed to '' the header name too