Spaces in " select from file" query

[fortres2]

Hi All,
I've got recordset which selects data from text file:

dim rs1 as new ADODB.Recordset
dim strSaveFilename as string

strSaveFileName = "C:\Program Files\Example folder\test.txt"
rs1.Open "SELECT * from [" & strSaveFilename & "] ;", _
connTXT, adOpenStatic, adLockReadOnly, adCmdText

but it works only if there are no spaces in strSaveFileName path. (it will fail in this example)

Please advise

 

[Remou]

What is connTXT? Why is this not:

connTXT = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Example folder;Extended Properties=""text;HDR=Yes;FMT=Delimited"";"

rs1.Open "SELECT * from [Table1.txt] ;", _
        connTXT, adOpenStatic, adLockReadOnly, adCmdText