>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

ODBC and OLEDB. Search for samples here.

Office 2007 compatibility issues Thread #1191826 Message #1191826

The thread is long. You may check from Re: Office 2007 compatibility issues Thread #1191826 Message #1192119
Cetin