Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from filename type xl5 crashes VFP
Message
From
22/06/2000 11:48:11
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00383176
Message ID:
00383208
Views:
16
>A co-worker was beginning to develop an app to import data from an Excel file and then do whatever manipulations were needed. He created a dbf by saving the files as dbase III format and then zapped the file (so was blank). Went into VFP and used the table he had just created. Issued the command: APPEND FROM filename.xls TYPE XL5 (also try TYPE XLS). VFP seemed to think for a moment and then just disappeard/shut down without notice. I decided to try this on my computer to see what the results were...exactly the same thing happened.
>
>Has anyone had this happen to them? Is this a known bug that I missed?
>
>Thanks,
>George


George,
Is .xls file in Excel5.0 format ? That's the only version AFAIK that doesn't have bugs with 'append from'. Also VFP6 SP3 has corrected some of the bugs.
'import from' might be a solution. Another one is to save as CSV, delimited or dBaseIII format from Excel.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform