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?