Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FoxPro and Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00766628
Message ID:
01135530
Vues:
26
Sure
Append From (lcExcelFileName) Type Xls
>I appreciate this myself; however, is there a way for the file name in 'Append From' to be dynamic, or user generated? I attempt to do this but only get an error that tells me that the 'file is not found.
>
>>Hi Steven,
>>
>>Maybe this can help:
>>
>>Create Cursor <yourcursor> (<your field defenitions>)
>>Select <yourcursor>
>>Append From 'yourexcelfile.xls' Type Xls
>>
>>There are also the types "Xl5" and "Xl8" which you can give an option sheet clause:
>>
>>Append From 'yourexcelfile.xls' Type Xl8 Sheet <yoursheet>
>>
>>See append from in VFP help
>>
>>>I have used FoxPro to generate an Excel spreadsheet before but now I want to use Excell data to feed into a FoxPro table from the Excel side can someone help me to get started?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform