import data from excel to access, such as 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!
 
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...

You might want to try an Excel or Access newsgroup.

--
Frank Saunders, MS-MVP, IE/OE
Please respond in Newsgroup. Do not send email
http://www.fjsmjs.com
Protect your PC
http://www.microsoft.com/security/protect/
 
Back
Top