#NUM! What does it mean?

S

simsga

In linking a new table to a .csv table, a date/time field and an account
number field (17 characters), I get this as a result
 
J

John Vinson

In linking a new table to a .csv table, a date/time field and an account
number field (17 characters), I get this as a result
Click to expand...

Use a Text datatype rather than a number (select the column in the
file import wizard and tell Access it's a text type field rather than
a number). 17 decimals is more than the default Long Integer datatype
can handle, and you'll never be doing math with this field anyway.

John W. Vinson[MVP]
 
Top