ADODB SELECT FROM filename with special character imbedded

[eadamy]

Function QS_CsvRecordsetOpen loads a CSV file and returns it as a Recordset. It works perfectly except when there is a special character embedded in pFilename which yields an error "Syntax error in FROM clause".

Please Login or Register  to view this content.

The special character is always the first character of the filename. I do not have control over the file names so I have attempted some workarounds based on review of general (non-VBA) SQL SELECT FROM syntax including:

• identifying and enclosing the special character in square brackets
• identifying the special character, converting it to a code, and inserting it into the filename with & Chr(code)

Is there any way to handle this with ADODB recordsets or do I have to revert to the old Input statement to read these? I can't find anything in searches except "don't use special characters in filenames" but that is not under my control.

Thank you.

[jindon]

If you have a problem with the file name, you can save a copy with a different name and read from there.