Excel Data Import

Hi,

I tried to import a data set from Excel in which total 16368 rows and 32 columns are recorded using Multiple Table Import. Importing seems to work fine, but it copied upto 16129 rows of data correctly. The remaining 239 rows are filled with all zeros across all columns. Could anyone help me to understand why it could happen and how to fix it?
I use Flexsim 4.3 version.

That's a lot of data, so you might want to consider the more suitable database import functions available in Flexsim.

I don't know if you're seeing a problem because of the amount of data, or something I experienced once on a project. I saw a similar effect of all zeros after a certain number of reads. The problem turned out to be some "corrupt" numbers in Excel. I traced it down to the fact it kept failing on cells that had a very large decimal number. I solved the problem by rounding the number of decimal places to something reasonable, and then Copy|Paste Special just the values to overwrite the original numbers in the offending cells. It's worth a try anyways...

thanks people, an excel import was driving me crazy for hours, but I found some "corrupted" cells containing long decimal numbers in my excel spreadsheet. I fixed that considering just 2 decimal digits, and it worked.