Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you access Excel via odbc?
Message
From
17/04/2000 17:21:10
 
 
To
17/04/2000 17:00:14
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00360621
Message ID:
00360650
Views:
13
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
Previous
Reply
Map
View

Click here to load this message in the networking platform