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
Regards
Geoff
>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
>>
>>
May all your weeds be wildflowers