import Excel sheet to Access, 46 becomes 45.99

  • Thread starter Thread starter h zhang
  • Start date Start date
H

h zhang

Hi, when import Excel sheet to Access.

I have the records like that in Excel

#1 46 15.50
#2 45.50 12.50

After the import,

I have the records like that in Access

#1 45.99 15.50
#2 45.50 12.50

Note the 46 in Excel becomes 45.99 in Access.

How can I solve the problem, make the 46 still as 46 in Access or as 46.00
in Access?

Thanks!
 
A stupid error. I didn't realize the Excel sheet column width is only 3
characters. So Excel round the numbers up in the view.
 
h zhang said:
Hi, when import Excel sheet to Access.

I have the records like that in Excel

#1 46 15.50
#2 45.50 12.50

After the import,

I have the records like that in Access

#1 45.99 15.50
#2 45.50 12.50

Note the 46 in Excel becomes 45.99 in Access.

How can I solve the problem, make the 46 still as 46 in Access or as 46.00
in Access?

Thanks!
Click to expand...
 
Back
Top