sql server - Malfunction of data copy from excel to Sql using BulkCopy (vb.net) -


i'm searching reason why importation excel sql table not working (via vb.net)

the excel file in input contains 1300 rows , 12 columns. 5 last columns contains prices. after importation, table if filled excel data except 2 last "price" columns data 'null'. strange thing "price" columns in sql destination table formatted same type (decimal(18,2)), in excel file. copy, use sqlbulkcopy , wonder if function not limited.

here's code:

        dim excelconnection new system.data.oledb.oledbconnection("provider=microsoft.ace.oledb.12.0;data source=" & ftransp & ";extended properties=""excel 12.0 xml;hdr=yes""")          excelconnection.open()          dim requeteexceltransp string = "select * [excelcetup$]"          dim objcmdselect oledbcommand = new oledbcommand(requeteexceltransp, excelconnection)          dim objdr oledbdatareader          using bulkcopy sqlbulkcopy = new sqlbulkcopy(connexionlinkystat)             bulkcopy.destinationtablename = "dbo." & tabletransp & ""              try                 objdr = objcmdselect.executereader                 bulkcopy.writetoserver(objdr)                 objdr.close()                 connexionlinkystat.close()              catch ex exception                 msgbox(ex.tostring)             end try         end using          excelconnection.close()

i trying 1 code, hope code helpful project

private sub button1_click(byval sender system.object, byval e system.eventargs) handles button1.click

     dim myconnection system.data.oledb.oledbconnection     dim dtset system.data.dataset     dim mycommand system.data.oledb.oledbdataadapter      dim fbrowse new openfiledialog     fbrowse         .filter = "excel files(*.xlsx)|*.xlsx|all files (*.*)|*.*"         .filterindex = 1         .title = "import data excel file"     end     if fbrowse.showdialog() = windows.forms.dialogresult.ok         dim fname string         fname = fbrowse.filename         myconnection = new system.data.oledb.oledbconnection("provider=microsoft.ace.oledb.12.0; data source='" & fname & " '; " & "extended properties=excel 8.0;")         mycommand = new system.data.oledb.oledbdataadapter("select * [sheet1$]", myconnection)         mycommand.tablemappings.add("table", "test")         dtset = new system.data.dataset         mycommand.fill(dtset)          myconnection.close()         each drr datarow in dtset.tables(0).rows             execute_local("insert excel(name, designation, salary) values ('" & drr(0).tostring & "','" & drr(1).tostring & "','" & drr(2).tostring & "')")         next         msgbox("successfully saved")      end if    end sub`

-

Comments

Post a Comment

Popular posts from this blog

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

Image
i having issues populating data in subreport in title band of main report. data populated correctly in subreport in detail band of main report. trying find wrong in json query. appreciated. json sample data source (expenses.json) { "expenses": { "date": "8 sep 2016", "accounts": [ { "title": "xyz corp (111)", "accountname": "xyz corp", "accountnumber": "111", "transactions": [ { "date": "21 jun 2016", "name": "gas", "price": "17.50" }, { "date": "12 may 2016", "name": "shopping", "price": "111.99" }, { "date": "30 apr 2016", "name...
Read more

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri...
Read more

SonarQube Plugin for Jenkins does not find SonarQube Scanner executable -

Image
i trying run sonarqube scanner within jenkins post-build step. however, keep getting error message below: ------------------------------------------------------------------------ sonar analysis failed ------------------------------------------------------------------------ fatal: sonarqube scanner executable not found sonarqube build step 'execute sonarqube scanner' marked build failure from similar questions on stackoverflow read 1 should choose "install automatically" sonarqube scanner, have done. my configurations follows: sonarqube 6.0 jenkins 1.609.3 sonarqube plugin 2.4.4 sonarqube servers sonarqube scanner build-step when config sonarqube scanner in manage jenkins --> global tool configuration --> sonarqube scanner, besides select "install automatically", need add installer. see screenshot here: sonarqube scanner --> add installer
Read more