"but is not nearly as convenient and flexible as IMPORT". I always thought the other way:)
Cetin
>Scott,
>
>I've been using SaveAs into 5.0/95 format. ODBC, as Cetin mentioned, is another route that avoids saveas, but is not nearly as convenient and flexible as IMPORT XLS.
>
>
>Pertti
>
>>I'm having trouble using the IMPORT command in VFP9 to load Excel 2007 files. I'm not surprised that the .XLSX extension files fail, but even files saved in newer formats than 5.0/95 seem to fail if they were created by Excel 2007.
>>
>>What alternatives are available for importing Excel files created by or saved by Excel 2007 into VFP9?
>>
>>- Manually using SaveAs
>>- Automation: SaveAs
>>- Automation: Cell by Cell access
>>
>>Others?
>>
>>Also, I noticed that Advisor has a workaround (
http://my.advisor.com/doc/19289) but my subscription expired last year. Anyone know the solution they suggested?
>>
>>Thanks,
>>Scott