Losing long numbers regardless of format


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.
 
Ad

Advertisements

P

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.
 
Ad

Advertisements

R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top