Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Excel Data in dotNet dataset with oledb
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using OleDB to get data from Excel | Excel Discussion (Misc queries) | |||
updating Excel from DotNet | Excel Programming | |||
Excel 2003: custom function with dotnet | Excel Programming | |||
Excel - DotNet - Variant Arrays as Params | Excel Programming | |||
Excel Workbook opened twice with dotnet interop | Excel Programming |