Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to handle Blanks (empty Rows)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
using fill handle with hidden rows | Excel Discussion (Misc queries) | |||
handle data with too many rows | New Users to Excel | |||
Excel should handle more than 65,536 rows. | Excel Discussion (Misc queries) | |||
To many rows for EXCEL to handle | Excel Discussion (Misc queries) |