Import problem

  • Thread starter Thread starter Nick
  • Start date Start date
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.
 
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
 
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?
 
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
 
Back
Top