Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing XLS into VFP8
Message
From
21/02/2011 21:24:16
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01501201
Message ID:
01501202
Views:
52
You can easily import the 2007 format into VFP8 without converting it by using EXCEL automation






>>When using the command:
IMPORT FROM XLSFILE.XLS TYPE XLS
I must first convert the xls file to type Microsoft Excel 5.0/95 worksheet. ( by loading into Excel and Save as... changing the type to MS Excel 5...)
If I leave the xls file in Excel 2007 type, VFP8 cannot load it.
My question is this: Will VFP9 import an Excel 2007 file without converting it to the older type?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform