import data from excel to access, such as 46 becomes 45.99

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

 

[Frank Saunders, MS-MVP]

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!

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/

 

[h zhang]

sorry, wrong group.