How do I preserve the CSV format after importing into access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying to import some CSV files into an MDB file. But in a case
where I have a long number in teh CSV file, Access automatically changes the
format.
For example, 5008111019 is formatted to 50081111000.
Whatv can I do order to save the actual format of teh CSV files.
 
You number is too big to store as Long (precision number) and JET converts
it to Double (inexact representation of number using mantissa and
exponential) to store it.

If you are not doing any calculation with this Field, import it as Text
rather than Numeric.
 
Back
Top