text coming through as scientific notation on import

[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

 

[Tim Ferguson]

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

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