When importing a CSV file into an Access database, number fields are automatically created as INT values. If you import a CSV file that contains numbers that are too high to be stored as INT, there is an error importing.
If you create the field in the target table as DECIMAL, it is fine and the numbers fit in.
Is it possible to change the default to DECIMAL when a large number shows up?
WORKAROUND:
None
STATUS:
Enhancement request CR 93269 has been submitted to Development for consideration in a future release of Toad for Data Analysts.
