Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with importing XLS files
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00589759
Message ID:
00589770
Views:
30
Sergey,

Thanks for the reply. Something tells me I should have given more information in my request. The Excel files I'm trying to import are from Excel files I created and sent out to sales reps from a table. As far as I know, there are no formulae in them. Most of our sales reps are not very technically savvy.

Normally, I do use the CSV format, but I don't think it will be necesary in this case.

- Gerry

>>I've got several Excel files I'd like to import. The first thing I've done is to convert them to Excel v4.0 format so VFP can handle them -- which I've done before. Now when I try it, I consistently get a VFP "Internal Consistency Error", which then closes VFP completely.
>>
>>Any suggestions, please? Besides saving thems as DBF's, which I will do, but I'm trying to figure what's wrong first.
>>
>
>Hi Gerry,
>
>If you're converting them anyway convert to CSV format. This way Excel preserves cell formating and VFP gets simple text file to import.
>
>Just a WAG, maybe you have formulas in some cells that VFP cannot process?
** Gerry White / Hagerstown, MD, USA --
** Developing since 1986 in Foxpro, VFP, Oracle, and Java.
** http://GerrysPlace.com
Previous
Reply
Map
View

Click here to load this message in the networking platform