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:
01180805
Views:
14
Hi,
FWIW, I use Excel 2003 and use TYPE XLS with no problem, but I have seen similar things when, say a file is originally create with 2002 when edited with 97.

Have a good day.

>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.?
>>>>
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform