text coming through as scientific notation on import

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I am importing an MS Excel file into MS Access. There is
one field of all numbers that I have set to text both in
the MS Excel file and in the Access table. However, a lot
of these, upon import, are showing up in the table as
scientific notation. How do I fix this?

thank you...

Craig
 
However, a lot
of these, upon import, are showing up in the table as
scientific notation. How do I fix this?
Click to expand...

UPDATE MyTable
SET MyNumber = Format(CDbl(MyNumber),"0")
WHERE MyNumber IS NOT NULL


Hope that helps -- but remember to back up first, in case it doesn't!!


Tim F
 
Back
Top