Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you access Excel via odbc?
Message
De
17/04/2000 17:21:10
 
 
À
17/04/2000 17:00:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00360621
Message ID:
00360650
Vues:
12
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform