Geof,
What's ODBC error returned by AERROR()? I tested it with Excel 2000 file. What's your excel file version? What table list is retuned by
? SQLTABLES(lnConnHand)
>That sounds neat, but I am getting a -1 (which is a connection level error) returned from the
>
>
>SQLEXEC(lnConnHand, [SELECT * FROM "Sheet1$"])
>
>
>Any idea why
>
>
>lnConnHand = SQLSTRINGCONNECT(lcConnStr)
>
>
>returns a positive number > than zero
>
>Regards
>Geoff Scott
>
>
--sb--