newcoder83
September 28th, 2009, 04:24 AM
Hi guys, really need urgent help..
I try to import excel into sql server 2000 table. I used oledb connection to get a dataset from excel file, and now i'm confused how to add all the rows from dataset into sql server 2000. Before insert or add row from dataset into sql server 2000 table, i want to edit some values from dataset because the values is not appropriate with sql data type, example in "QTY" column which is integer data type there is still "-" or character values. How can i edit the values from dataset? how can i retrieve the data from dataset and add it into sql server 2000 table.
THanks in advance.
I try to import excel into sql server 2000 table. I used oledb connection to get a dataset from excel file, and now i'm confused how to add all the rows from dataset into sql server 2000. Before insert or add row from dataset into sql server 2000 table, i want to edit some values from dataset because the values is not appropriate with sql data type, example in "QTY" column which is integer data type there is still "-" or character values. How can i edit the values from dataset? how can i retrieve the data from dataset and add it into sql server 2000 table.
THanks in advance.