SQL Query from a File

[hoangvo81]

I can run the below sql directly from MS Access

select * from [text;database=C:\test].[fixedDataLengthFile.txt] as pm

but when i tried to put that into DBQuery it doesnt recognize it. Any suggestion other than reading the file using ReadLn
?

[hoangvo81]

Nevermind,
I saw the article about querying csv files and schema.ini
Will try that tomorro