Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel 2010 64 bit and VFP
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel 2010 64 bit and VFP
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01533212
Message ID:
01533212
Vues:
113
Hi everybody,

I am wondering what methods should we use working with the Excel file where we have Office 2010 64 bit installed.

I've created an Excel file by copying results of several SQL statements (I gave up with my tries with SSIS and had to execute queries manually and copy results to appropriate sheets in Excel).

Now I want to be able to read these results into VFP. I found Craig Boyd's VFPExcel function. I tried it on the very first sheet which only has a single value in the first cell. Only the last SQLStringConnect from that function succeeded, but it didn't read the value.

I am going to try right now with the table that has many fields and header row, but I'm not sure it will work. If not, what are my options?

Thanks a lot in advance.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform