Importing Text File

[Five-O]

When I import a text file some of the fields with zeros do not import. The
fields are blank. No rhyme or reason why some zero fields import and some
don't. I have written an update query to add the zeros but is there way to
correct the import problem??

 

[Klatuu]

How are you doing the import?
What created the text files?

If you can answer these two questions, I can show you how to make it work,
and possibly explain why some 0 field import and some don't.

 

[Five-O]

I download the data from a mainframe, changing the format to a text format.
The data is then imported as text delimited into Access.

Importing the data worked great using Access v2.0, but never could get the
same results using Access 97 or Access2000.

I hope this answers your questions.

 

[Klatuu]

Question is, are you using TransferText, reading it in programmatically,
cutting and pasting, or whatever.

What I would check it the text file. I don't know about your mainframe text
file, but Excel, for example, has a habit you have to check for. If an Excel
cell is formatted as General, and nothing has been entered, it import to
Access as Null and it exports to text as nothing. for example, you may be
expecting:
JONES,3,7,99,0,X

You Get:
JONES,3,7,99,,X

Which will import int Access as an empty string into a text field and as
Null into a number field.

Try setting up an Import Spec for your text file and see if that solves the
problem.