Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from XLS Crashes VFP
Message
 
 
To
24/10/2003 03:56:01
Jeffrey Havelock
Skipton Information Group
Leeds, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00841969
Message ID:
00842055
Views:
24
Jeff,

There is a KB article on MSDN that talks about this. Believe it or not it's dependent on how much "pasting" has been done in the spreadsheet. You have two options, 1) save the file as something like CSV from Excel and import that file, 2) use Automation and read the spreadsheet cell by cell from VFP. #1 is a couple of orders of magnitude faster to run.

>I'm trying to append an MS Excel 2000 file into a fox table (VFP 6.0). However, when I endter the command "APPEND FROM 'Sales Ledger.xls' TYPE XLS", FoxPro instantly closes! Does anyone have any ideas on this?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform