Geof,
Browse cursor created by SQLTABLES to see what you have in the table_name column. That's what you can use as a table name in the queries.
>
>aODBC(1,1)=1526
>aODBC(1,2)=Connectivity error: [Microsoft][ODBC Excel Driver] 'Sheet1$' is not a valid name.
>
>
SQLTABLES(lnConnHand)
>
>returns 1
>
>I am not sure what version the excel model was created/saved with. How do I find out???
>
>The sheets' original name was 'Export_to_Contractor_Temp_of_Jo', possibly more, so I tried renaming to 'test' and then
>
>
SQLEXEC(lnConnHand, [SELECT * FROM "test"])
>
>but with no luck
--sb--