Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel 2007
Message
De
21/07/2009 16:50:15
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
21/07/2009 13:07:08
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01413572
Message ID:
01413633
Vues:
55
>>>To make our application work with Excel 2007 the IMPORT command doesn't work anymore and reading MS article http://support.microsoft.com/default.aspx?scid=kb;en-us;949529 we want to go with the ODBC route and the SQLEXEC but the article states to download "The 2007 Office System Driver: Data Connectivity Components package" I've never downloaded that and the Excel driver works for me. Does this get installed with Office 2007 by default or do I need to make this a prerequisite for our application if you want to use Office 2007?
>>
>>Drivers get installed by Excel installation and you can also install on demand. I use OLEDB drivers and happy with it. Maybe you should prefer over ODBC connection too. Check this if you want:
>>
>>http://www.foxite.com/archives/0000153776.htm
>>
>>Cetin
>
>Thanks but I really need it in a FoxPro table and from my experiences using ODBC to get directly into a VFP table is a lot faster then ADO to VFP table.

That is true, ODBC might be slightly faster and you might gain less than 200 milliseconds maybe. However it would worth to see if you can get ODBC with Excel working. I haven't seen yet.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform