import Excel sheet to Access, 46 becomes 45.99

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!
 
H

h zhang

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

Heinz-Otto Hoesen

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import data from excel to access, such as 46 becomes 45.99 2
SUMPRODUCT where between 2 dates 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import from Excel 2003 to Access 2003 4
checkif/sumif question 2
Adding headers 2
Retaining Time Format when Importing 1
How to export table from outlook into ms access table? 0

Top