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