Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FoxPro and Excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00766628
Message ID:
01135530
Views:
25
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform