Losing long numbers regardless of format

[reneecolo]

I'm trying to import a tab-delimited text file with account numbers up to 11
digits long. The text file does not have quotes around text fields and they
cannot be added. No matter how I format the account number field (Long
Integer, Double, Text), I get type conversion import errors. I can get all
the account numbers into a table if I create a new table during import, but
when I try to append the next table, I have the same problem with type
conversion import errors. I'm baffled, because I've never had this problem
until I upgraded from Access 2003 to Access 2007.

 

[Piet Linden]

I'm trying to import a tab-delimited text file with account numbers up to11
digits long.  The text file does not have quotes around text fields andthey
cannot be added.  No matter how I format the account number field (Long
Integer, Double, Text), I get type conversion import errors.  I can getall
the account numbers into a table if I create a new table during import, but
when I try to append the next table, I have the same problem with type
conversion import errors.  I'm baffled, because I've never had this problem
until I upgraded from Access 2003 to Access 2007.

If you don't use the account numbers in mathematical operations,
they're logically not numbers. Store them as text and your problem
goes away.

 

[reneecolo]

Tried that. It seems to completely ignore the formatting of the account
number field. When I tried the same process on another computer using Access
2003, I was able to import the text files into one table without a hitch.
However, I cannot find any settings in the 2007 version that change how it is
importing.