Writing SQL results to a .txt

[tnhall]

I am new to the macro scheduler world.
Is it possible to write MS Access query results to a .txt?
Also, please validate the connection string. I am trying to connect to MS Access 1997 database. What I have isn't working.

Let> str=oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=C:\Program Files (x86)\TapWatch2\Databases\TWMain.mdb;"
DBConnect>str,dbH

Let>SQL= SELECT "C:\Program Files (x86)\TapWatch2\Files" & Propertyidentifier & "\" & Propertyidentifier & " Auto Download.lnk" AS Expr1
FROM SiteInformation;
DBExecute>dbH,SQL,result

DBClose>dbH

[JRL]

Try looking here for a workable connection string.

HERE is Marcus' spectacular SQLtoCSV script.

[tnhall]

Try looking here for a workable connection string.

HERE is Marcus' spectacular SQLtoCSV script.

Exactly what I was looking for. Thank you, JRL!

[troytubbs]

I am also a newbie in this, and I'll be thankful if someone could describe this process.