Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem importing from Excel file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01180794
Message ID:
01180804
Views:
14
Yes, I had thought of that, but not gotten to it yet (I was doubtful about that solution, since this is Excel 2002). I just tried it. Unfortunately, my doubts were correct. Same problem. But then I just saved it in the Excel 5.0/95 format and the problem is solved.

This is one of the irritating issues with VFP - that they haven't updated the capabilities of import/export as the newer versions of Excel have come out. I don't always see this problem, but I did in this spreadsheet for some reason.

Thank you for your help.

>Also, try TYPE XLS, it may not be an Excel 97 original format.
>
>>No, they are visible. I did a Clear on them (hightlight the cells, Edit/Clear/All) and tried the import again and got the same thing.
>>
>>The code is:
>>
>>
>>CREATE CURSOR ImportCursor;
>>	(item c(15), price n(10,2))
>>APPEND FROM <ExcelFileName> type xl8
>>
>>
>>>Hi,
>>>Are the rows hidden in the spreadsheet.?
>>>
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform