I am importing data from Excel sheet to SQL Server to store in a table using an aplication

Question

I have one Excel sheet, in that plenty amount of data is there, so need to write these data in the SQL server table directly. I searched in google but I didn't found a proper solution for my requirement.

My Excel contains the data in row wise, I mean that data is not continually provided. Having sub headings & some other information about tables description written after every table ended.

I hope you all understand my requirement. Please anybody have idea about this issue, or alternate solution to resolve. Have to store this excel data in to the SQL server table.

Here data is columns as rows & rows as columns. So how to read in this case.

firstname      vijay      vikram     vikek      varun

lastame        kumar      rathod      goshal    kandari

mobile         45425      456546      54656     454615

Like above my data in excel sheet so how capture this kind of data.

Please check this link. Hope it helps http://stackoverflow.com/questions/657131/how-to-read-data-of-an-excel-file-using-c — shakz, Oct 19 '12 at 07:53

score 0 · Answer 1 · edited May 23 '17 at 12:32

0

Did you try using a excel interop.Using interop you can even read particular cells.You can read values by specifying a range and build a datatable or list.

These links may help

http://sandeep-aparajit.blogspot.in/2008/08/how-to-read-excel-in-c.html

C#: Getting a cell's value with Excel.interop

edited May 23 '17 at 12:32

Community

1
1

answered Oct 19 '12 at 07:26

Karthik

2,391
6
34
65

Thank you very much....yes, i know that. but data will be not in proper order. rows are inserting as columns and columns are inserting as rows in database. – Vinod Bheemisetty Oct 19 '12 at 11:44
specify the cell range and retrieve values – Karthik Oct 19 '12 at 12:07

score 0 · Answer 2 · edited Oct 19 '12 at 08:19

0

If you want to insert data into db directly, without front-end functionality, then you can do it by using SSIS packages or import functionality available in SQL server

edited Oct 19 '12 at 08:19

SchmitzIT

9,227
9
65
92

answered Oct 19 '12 at 08:16

Pradeep Kumar Sharma

1

Thank you very much...yes, i know that. but data will be not in proper order. rows are inserting as columns and columns are inserting as rows in database. – Vinod Bheemisetty Oct 19 '12 at 11:43

score 0 · Answer 3 · answered Dec 10 '12 at 06:12

I have tried importing data from excel to sql server table. The process is in sql server right click on particular database and under tasks tab select import data option then select source excel file and destination table. It's working fine for me.

Thanks Venkat

I am importing data from Excel sheet to SQL Server to store in a table using an aplication

3 Answers3