Click here to Skip to main content
15,885,757 members

How to import excel data to SQL database table

Revision 2
Hello sir,

I have excel sheet and it contain Name Field and ID field. In my database name as Personal which has Name and ID fields.Now I need to import data from that excel sheet and insert that all data into Personal table in my database.Please tel me how i do this.Data in excel sheet is given below as example
Plz help me.....

XML
Name    ID
a   1
b   2
Posted 2-Oct-12 10:26am by n1985.
Tags: ,