Say there is a table as follows:
Sourceid destid tableid make
96 96 2 ZB
96 96 2 PN
95 98 3 KL
96 96 2 DR
95 98 3 DW
90 97 2 SE
Now I need...
I am reading from and excel file using OLEDB.
Due to mixed data types in a column im getting null values inserted into my dataset when i read the...
I have an excel file which has say 5 columns. I know the datatypes of the data in these columns.
I then have to get this from the excel in a...
Is there any way to insert a new column into an existing excel file.say Example1.xls
One way would be to copy the contents of Example1.xls...
I have an excel file say ExcelAdaptor.xls having sheet name as ExcelAdaptorErrors and having columns say 'ID','Message'.
Please let me know any...
Separate names with a comma.