Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sundarsrini_s
Starting Member
6 Posts |
 Posted - 2008-06-10 : 05:25:30
|
| hi! i am using bulkcopy() function to export the data from excel file to datatable through asp.net.but if there is any column having both number and text then the numbers are exported as null to the datatable.here is my coding:Dim sSQLTempTable As String = "sqltemp" Dim bulkCopy As SqlBulkCopy = New SqlBulkCopy(sSqlActConnection) bulkCopy.DestinationTableName = sSQLTempTable bulkCopy.WriteToServer(OleDbrdr) for examplefield1 field21 text12 563 text24 785 98when i export like these, the records in datatable are:field1 field21 text12 null3 text24 null5 nullwhy it export as null?reg,s.srini |
|
|
|
|
|
problem when using sqlbulkcopy()