Import problem

N

Nick

I have a file that has a number of blank spaces or Lines
in the first three heading befor I get to the real data.
I have set the to disregard the first heading but how do
you loose the next two.
Example
heading line 1 has a "blank" sell. Then below in heading
line 2 has "______________". Heading line 3 is the
beginning of data.
 
T

tina

one solution: see if you can identify a field in the table where 1) the 3
"header" rows are *always* blank, or have a useless value such as an
underscore ( _ ) and 2) that same field *always* has valuable data in the
"real" records.
if you can identify a field that meets the above criteria, then set a
validation rule on that field in the table, to prevent import of the records
you don't want. for instance, if you find a field that is always null in the
"header" records and always has data in the "real" records, then set that
field's validation rule to Is Not Null.

hth
 
T

tina

to answer your question: yes, enclose the underscore in double quotes.
but...
did you identify a field that *always* has either a Null value or an
underscore in the header rows, but *always has valid data in the data rows*?
or are you just taking my example without checking?
 
N

nick

Tina,
The Id_number feld is either empty, has an underscore or
has valid data in it. The first two rows in the "Id"
feilds are Null or have an underscore the daya below that
is always valid. I will try the validation rule and get
back with you. Thanks
 

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