Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FoxPro and Excel
Message
 
To
17/03/2003 16:05:51
Leo Kool
Agis Automatisering BV
Harmelen, Netherlands
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00766628
Message ID:
01135518
Views:
23
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform