Return
-
Title
Unable to import large numbers into default INT number field -
Description
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?
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.