>>>>VFP IMPORT command does not work with Excel 2007 and later. See Microsoft Visual FoxPro fails to import Microsoft Excel 2007 Workbook saved in "Excel 97-2003 Workbook" format. >>>>Check Using Excel 2007 File Formats in VFP 9.0 and Importing data from a Microsoft Excel 2007 workbook using Visual FoxPro 9.0 for alternatives >>> >>>Thanks Sergey...I've been importing Excel 2007 for years, by detecting that VFP can't handle it, than saving it to an Excel file of an earlier version...I CAN IMPORT and can deal w/the data, it's just that weired column naming...in the source Excel file the columns are named ....DU, DV, DW. >>> >> >>Let me repeat it again, VFP IMPORT command does not work with Excel 2007 and later files. You're IMPORTing one of previous versions and should have made it clear from the beginning. > >Sorry, i thought it was clear, in that the file WAS imported w/out an error from VFP.
Before saving the file in earlier version make sure to unhide all columns. In the routine I sent you there is a code that does that.