Last post Jul 02, 2012 05:56 AM by Dino He - MSFT
Jun 29, 2012 09:42 PM|Waqar Hasan|LINK
Can any one help me plz
i m trying to extract excel sheet using data table + sqlbulkcopy and oledb a
problem is tha if i dont use column mapping got following error
"The given value of type String from the data source cannot be converted to type nvarchar of the specified target column."
and if i used column mapping Then
Its working for simple data but when i m trying to use our original sheet. data is saved in only 3 column remaining 9 column is shown NULL while they have contain data in excel sheet.
All columns have nvarchr(max). Data for one column which is not saved in db columns and show null is "abc.aaa.scdd.aaa " and one other column which is showing null is " a sentence containing (brackets) and also commas, which data type should be used
for these data. "
Jul 02, 2012 05:56 AM|Dino He - MSFT|LINK
Did you resolve this ?