Hi,
I have a strange problem, I am picking up data from a
spread sheet

1)The first row has a 10 Cells merged into one column
called 'BE', the next next 10 Cells merged into another
called 'DR'and the next next 10 Cells merged into another
called 'CR', So effectively I have 3 Columns
2)Under BE,DR,CR I have another set of headers
say 'BE1','BE2'...'BE10' Similarly 'CR1','CR2'...'CR10'
Filters are applied on all the columns in the second row
Under these sub headings I have actuall Data

Now I pick up data and put it in a text file, The problem
starts in some cases I am getting the second row values
'BE1','BE2' And so on In some cases I am getting Null
I want all the sub headings in the second row to be picked
up for some strange reason its not picking up all the
columns only some getting picked some or not I am not able
to find out why?
Sunny

Hi sunny,
Maybe this is you problem.
http://www.sqldts.com/default.aspx?6,222,254,0,1
JFB

"sunny" <sunnyboy63 (AT) yahoo (DOT) com> wrote