Hello,
I got Excel file with data taht I should migrate into SQL Server database.
The problem is that it contains some cells that are merged. I tried to create
SSIS using Excel Source but if multiple cells (in a row) are merged together,
it returns value only for the first cell and for the rest the returned value
is null.
E.g. when A1='x', A2='y' and B1 is merged with B2 and contains value 5, then
for area A1:B2 I get rows:
x, 5
y, null

This is not what I would expected as from my point of view B2 should refere
to the same value as B1.
The file is quite big and changing frequently. I need some preprocessing or
other way how to automatically retrieve the same value for all merged cells.

Any idea?
(I can do programming but I'm not much familiar with VBA and Excel DOM so
please don't be too brief in the response.)

Thanks a lot
eXavier