excel import problem

0
while importing data into db from excel using excel importer, some integer values of a column are getting decremented by one(60->59, 15->14….). It's happening randomly for some values, dont see any pattern there. Any ideas on how to fix this??
asked
1 answers
0

Is it possible that they're not actually integer values in Excel, but they're shown rounded there? Could be that the import rounds down where Excel rounds up, for instance.

answered