Importing text file data type problem

[ScrmingWhisprs]

I have created a table by importing data from a .txt file. The text file is tab-delimited and exported from Google Spreadsheets. The fields are:

Timestamp
First Name
Last Name
Street Address
City/Town
State
Zip
Phone
Birthdate
Email

When I first imported the data into the brand-new table, i selected the data type for each field. Specifically setting Zip and Phone to Text. After importing, all the data in the table looks fine. I try to import more data into the table (even from the same file), and there are import errors. The Zip Codes (which begin with a 0) are missing the leading 0 in the table. So the data from the first import has Zip codes that look like this: 02909, the second import looks like this: 2909.

The field types in design view of the table are set to text for Zip Code. Other threads I read talked about this when importing from Excel. Where you have to make sure Excel knows it's a text field. However this is a simple unformatted text file, that clearly has the full Zip Code (02909).

Any help would be appreciated.

Thanks!
ScrmingWhisprs

 

[RuralGuy]

That is just Access trying to "help". Make sure the Import spec is a Text field for those fields. If a field begins with a number then Access seems bent on making it a numerical field.

 

[gemma-the-husky]

silly point, but are you sure the zero is there in the text file

you are probably better creating an import spec, as you get more control that way.