Importing tab delimited files to access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I maintain a database at an external site. Weekly I download this inventory
in a tab delimited file. One of the columns in the database is product Id.
This consists of a ten digit number almost always beginning with a zero.
When I import the tab file the zero is stripped giving me a 9 digit number
which will not work. With 6500 records I can't go back and change each one
every week.

Any suggestions?
 
if you just need to "see" the leading zero, just format the field in the
Access table to show 10 digits, as

0000000000

if you need the leading zero to be saved as data in the field, change the
field's data type from Number to Text.

hth
 
When you setup the import spec you should define the field type as Text not
Numeric.
This will preserve the leading zeros during import.
 
Back
Top