Having problems with import

[Nick]

I am having a problem with importing a text file to
access. The first entry is null, I can screen that one
out but the next one is "________" and am unable to
screen that one out. What should I do?

 

[John Nurick]

Hi Nick,

Can you be more explicit about what you mean by "screen out" and
"entry"?

The Access text import routine doesn't let you reject records. Instead,
you can

*link - rather than import - the file and then use an append query to
move the records you want into your table, or

*import the data and use a delete query to dispose of the records you
don't want.

 

[Guest]

Yes, I am using the validation rule when importing the
text file. I currently have it set to import data that
is not Null in the first field of the table but It also
must prevent the next line which is listed as "______".
to be listed when imported. I have tried Is not Null or
not "______" but when set up this way it accepts the Null
entry. Is their anything else I can do?

-----Original Message-----
Hi Nick,

Can you be more explicit about what you mean by "screen out" and
"entry"?

The Access text import routine doesn't let you reject records. Instead,
you can

*link - rather than import - the file and then use an append query to
move the records you want into your table, or

*import the data and use a delete query to dispose of the records you
don't want.

I am having a problem with importing a text file to
access. The first entry is null, I can screen that one
out but the next one is "________" and am unable to
screen that one out. What should I do?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Nick,

If you want to reject values that are either Null or "_____", you can
use a validation rule like this:
(Is Not Null) And (Not Like "____*")

In a query you'd use something like
WHERE (TheField Is Not Null)
AND (TheField Not Like "___*")

Yes, I am using the validation rule when importing the
text file. I currently have it set to import data that
is not Null in the first field of the table but It also
must prevent the next line which is listed as "______".
to be listed when imported. I have tried Is not Null or
not "______" but when set up this way it accepts the Null
entry. Is their anything else I can do?

-----Original Message-----
Hi Nick,

Can you be more explicit about what you mean by "screen out" and
"entry"?

The Access text import routine doesn't let you reject records. Instead,
you can

*link - rather than import - the file and then use an append query to
move the records you want into your table, or

*import the data and use a delete query to dispose of the records you
don't want.

I am having a problem with importing a text file to
access. The first entry is null, I can screen that one
out but the next one is "________" and am unable to
screen that one out. What should I do?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[Nick]

Thank John,
I will try it on Monday.

-----Original Message-----
Nick,

If you want to reject values that are either Null or "_____", you can
use a validation rule like this:
(Is Not Null) And (Not Like "____*")

In a query you'd use something like
WHERE (TheField Is Not Null)
AND (TheField Not Like "___*")

Yes, I am using the validation rule when importing the
text file. I currently have it set to import data that
is not Null in the first field of the table but It also
must prevent the next line which is listed as "______".
to be listed when imported. I have tried Is not Null or
not "______" but when set up this way it accepts the Null
entry. Is their anything else I can do?

-----Original Message-----
Hi Nick,

Can you be more explicit about what you mean

by "screen
out" and

"entry"?

The Access text import routine doesn't let you reject records. Instead,
you can

*link - rather than import - the file and then use an append query to
move the records you want into your table, or

*import the data and use a delete query to dispose of the records you
don't want.

On Mon, 19 Jul 2004 21:18:15 -0700, "Nick"

I am having a problem with importing a text file to
access. The first entry is null, I can screen that one
out but the next one is "________" and am unable to
screen that one out. What should I do?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.