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.
>>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