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

P

pablo

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.
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create custom labels from an csv file + Need items numerically counted out 0
CSV Import Error 2
Excel And Notepad 3
Cannot import CSV file into ACCESS 1
import csv truncation 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
|9 can't find the field '|' Error when importing a csv to Access 2 1
Address Format changed after Migration 0

Top