Looks like you're correct. I was going off never having seen anyone talk about ODBC to Excel, while I've seen several ADO to Excel threads elsewhere.
PF
>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
(On an infant's shirt): Already smarter than Bush