It would appear that I need to have a
$ after the sheet name.
Looking at the correct spreadsheet also helps.
:)))
Most of the fields come in as memo fields which should resolve the problem.
Thanks once again Sergey
Regards
Geoff Scott
>
>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