main logo
Subject: Importing from Excel 2007
Author: "Scott King"
Posted: 2007/11/30 15:09:44
 
View Entire Thread
New Search


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




 
©2007 Scott King
<-- Prior Message New Search Next Message -->