#NUM! What does it mean?

[Guest]

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

 

[Van T. Dinh]

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=209132

and

http://support.microsoft.com/?id=208414

 

[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

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]