I am pulling information from a CSV into a recordset
I can read the csv fine to run an "open for append" sub.
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.
The locals is pulling the query through fine
Unfortunately because the process is passed to ACE, VBA isn't able to give much information on what is wrong.
|"SELECT * FROM TestFile.csv WHERE PartNo = ACTEST"