Any question answered...

You are reading a single comment by @chez_jay and its replies. Click here to read the full conversation.

•

hugo7

I'm teaching myself MS Access to build a database that uses data from xls which has a series of numbers that are percentages.

When I import it just converts to 0 or 1.

Any ideas why?

•

chez_jay in reply to @hugo7

percentages are stored in Excel as floats from 0 to 1 and you are storing as integer in Access, so they are being coerced by rounding down to 0 or up to 1?

About

Avatar for chez_jay @chez_jay started