Losing long numbers regardless of format

  • Thread starter Thread starter reneecolo
  • Start date Start date
R

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.
 
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.
Click to expand...

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.
 
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.
 
Back
Top