F
Fabien
Hello ,
I am working on a project and i have a very important question.
I try to import exce data into dotnet dataset.
When one of the cells is blank, all the cell below will be imported in the
dataset as System.dbnull values.
I am using the property imex=1 and the regedit values are ok (Text,...) to
solve the datatype problems.
My cells in excel sheet are in Text.
When the cell is blank but with a space for exemple, the import is ok
because it is interpreted as a string value.
When the cell is blank with no data the imported of the data below this
column value are imported as null value.
It does two days that i am trying to solve this problem, i dont find a
solution. i have tryed to reinstall oledb jet 4.0 drivers and mdac drivers...
Nothing to do.
(My excel will contains a lot of values, so i can not to special characters
for each blank cells that i would replace later in my dotnet code)
I am using dotnet 2003, access 2000, excel 2000, win xp pro
Have you a solution ?
Please help me....
Thank you very much
Decroux Fabien
I am working on a project and i have a very important question.
I try to import exce data into dotnet dataset.
When one of the cells is blank, all the cell below will be imported in the
dataset as System.dbnull values.
I am using the property imex=1 and the regedit values are ok (Text,...) to
solve the datatype problems.
My cells in excel sheet are in Text.
When the cell is blank but with a space for exemple, the import is ok
because it is interpreted as a string value.
When the cell is blank with no data the imported of the data below this
column value are imported as null value.
It does two days that i am trying to solve this problem, i dont find a
solution. i have tryed to reinstall oledb jet 4.0 drivers and mdac drivers...
Nothing to do.
(My excel will contains a lot of values, so i can not to special characters
for each blank cells that i would replace later in my dotnet code)
I am using dotnet 2003, access 2000, excel 2000, win xp pro
Have you a solution ?
Please help me....
Thank you very much
Decroux Fabien