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:
01180797
Views:
15
Hi,
Try deleting the 10 rows immediately below the data, if the rows/cells are protected Clear All doesn't work.

>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.?
>>
>>>I have a situation where I'm importing data from a simple two column spreadsheet. There are 894 rows. All 894 rows import just fine, but at the end of the file I get some junk.
>>>
>>>This is what I get. As you can see, the last record (and all the ones before that) is imported fine, but I get three additional records. Lines 895, 896, and 897 in the spreadsheet are completely empty - no data, no formula.
>>>
>>>
>>>Record#  ITEM               PRICE
>>>    894  7580KTPA           55.05
>>>    895  0
>>>    896  7.7468171E-304
>>>    897                     3.33E-308
>>>
>>>
>>>Unfortunately, I get a numeric overflow error. But where the heck does it find this nonexistent data?
>>>
>>>Russell Campbell
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform