Database Error

[ken gray]

I'm having problems with a query to a text file.  I'm not sure what I'm doing wrong here; can someone see what I'm doing wrong?

Macro Macro6

Code:

Copy      Help

Database dbt.Open(dbt.CsText("C:\Temp\move.txt"))
ARRAY(str) at
dbt.QueryArr("SELECT * FROM move.txt" at)

I get the below error.

Code:

Copy      Help

Error (RT) in <open ":3116: /11">Macro6:  0x80004005, Unspecified error.
    [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.  Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.    <help #IDP_ERR>?

The file is there as I used the 'copy as path' method from Windows Explorer.

Thanks.

[Gintaras]

Must be folder path.
...CsText("C:\Temp"))

[ken gray]

doh!  yeah, I wasn't outputting the result when testing either which made me think it was failing.
thanks.