Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import Excel spreadsheet into VFP using my VFP program?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00705123
Message ID:
00705131
Vues:
12
>Currently I use Excel to export a spreadsheet to VFP DBF format that VFP can read. Then I read the imported VFP DBF file using a front-end program that I wrote which rewrites the records into a better field structure for reporting purposes.
>
>My question is
>Is there a command or set of commands that I can put in my front-end program that will do the Excel spreadsheet to VFP BDF file conversion automatically and save me that step or will the export from Excel to VFP always be a manual process?
>
>Thanks for the help.

Hi,

You could use Excel Automation or retrieve data into VFP directly using Jet ISAM driver for Excel and ODBC or ADO. Here a sample of ADO connection string:
lcConnString = [Provider=Microsoft.Jet.OLEDB.4.0;] + ;
[Data Source=c:\SourceData.xls;] + ;
[Extended Properties="Excel 8.0;"]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform