>Ok, I'm pretty frustrated with attempting to IMPORT a large Excel spreadsheet into a table.
>
>[[Side Note: WHY does VFP 6.0 still have "Excel 5.0" as the latest version of Excel in it's list of import types -- Geez!]]
>
>I have tried every way to import all the data from a 62 Column by 75640 Row spreadsheet into a table, including the IMPORT command, the import dialog in VFP, "Save As" from Excel into a .DBF (again OLD DBase versions), and I either only get a little more than 16,000 records or I get all the records, but NOT all the columns. DAMN FRUSTRATING for working with the newest version of VFP and the newest version of Excel.
>
>[[Side Note #2: MY VFP 7.0 "wish list item" ... FIX THIS!!!]]
>
>Anyway, so I guess I have to resort to Automation. I can instantiate Excel and open the file, but can someone tell me how to pull in EVERY row and column which contains data from the spreadsheet into a table.
>
>Thanks.
IMHO saving to a text or dbf file would be the fastest.
#define xlDBF2 7
#define xlDBF3 8
#define xlDBF4 11
oExcel.ActiveWorkbook.Activesheet.Saveas(cFilename, nSaveAsFileFormat)
Cetin