Hey, I wasn't giving up that easy. Can you believe I actually found a VFP example on MS web site! You need to do something like ...
h = SQLCONNECT()
? SQLEXEC(h,'SELECT * FROM "Sheet1$" Sheet1_')
And it actually worked!
BTW, the kb article is
http://support.microsoft.com/support/kb/articles/Q131/5/80.asp and is about getting the wrong data types.
-Isaac
>While I haven't tried and can't testify to the practicality, I believe this is incorrect. An ODBC driver for Excel files intalls with several products.
>
>I think a more accurate statement would be that ODBC is for tabular data that lends itself to display/storage in rows and columns. Excel falls into that category.
>
>
>>ODBC is only for database products. ADO allows for connecting to other types of sources, so long as they have an OLEDB provider. Excel falls into that category.
>>
>>PF
>>
>>>Does anyone know if an excel spreadsheet can be accessed using odbc? I have tried and get as far as connecting, but I don't know and cannot figure out what table name to select from.
>>>Anyone done this?
>>>
>>>Thanks,
>>>-Isaac