1 Replies - 12779 Views - Last Post: 30 March 2014 - 03:14 AM Rate Topic: -----

#1 gpt16   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 30-March 14

How to import excel data into sql table via vb.net?

Posted 30 March 2014 - 02:25 AM

i am very new in .net platform

actually i am trying to import excel data(With 2 columns) in my Microsoft SQL database table (with 2 columns) with help of window form.

I am totally out of understanding how to start it.i tried with many stuff (books) i didn't got anything.

you can analysis better from uploaded images what i am trying to say!!

note:

Excel information:


excel name:- branch.xlsx
sheet name:- Sheet1
2 columns name:- branch id and branch name

Database information:

database name:- test.dbo
table name:- branch
2 columns:- branchid and branchname


form name:- form1.vb

highly appreciated for solutions with codes!!

please help me !!
Attached Image

Is This A Good Question/Topic? 0
  • +

Replies To: How to import excel data into sql table via vb.net?

#2 andrewsw   User is offline

  • quantum multiprover
  • member icon

Reputation: 6775
  • View blog
  • Posts: 27,938
  • Joined: 12-December 12

Re: How to import excel data into sql table via vb.net?

Posted 30 March 2014 - 03:14 AM

A quick search of "vb.net import excel to sql database" yields a number of results.

http://stackoverflow...sql-server-2008

Quote

highly appreciated for solutions with codes!!

Do not ask for "solutions with code". Members here will help you if you make some effort.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1