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

Click here to load this message in the networking platform