Good day all,

I have developed an Upload from excel to and ERP system. The way it
works is it will use OLEDB to run a select statement for fields that I
need, then i insert the results into a DataSet and form the dataset
its uploaded to the ERP system after a number of integ checks. This is
done for 100 diffrent xls file at a time.

There is how ever quite a big problem (isnt there always :P) when I
reach a file that starts with lest say more than TWO blank rows
(excluding HDR), the select statment exsits and no other data is
returned, for example:

Data EXAMPLE:

F1 F2 F3 F4
BLANK BLANK BLANK BLANK
BLANK BLANK BLANK BLANK
BLANK BLANK BLANK BLANK
BLANK BLANK BLANK BLANK
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA

And I run Select F1,F2 ,F3,F4 from [Upload ERP$] the returned dataset
is 0 records ..... EVEN though after the four blank rows there is data
that should be retrived!!

But if the data is formatted as

F1 F2 F3 F4
DATA DATA DATA DATA
BLANK BLANK BLANK BLANK
DATA DATA DATA DATA
BLANK BLANK BLANK BLANK
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
DATA DATA DATA DATA
BLANK BLANK BLANK BLANK
DATA DATA DATA DATA
BLANK BLANK BLANK BLANK
DATA DATA DATA DATA
BLANK BLANK BLANK BLANK
DATA DATA DATA DATA

Then the same select statement will work and just ignore the blank
rows, is there something I am missing here?

Thank you for your time.

Carlos Magalhaes