how to insert the excel sheet into database and how to retrieve the data from excel sheet

Posted by Tejamanimala under C# on 11/18/2013 | Points: 10 | Views : 10842 | Status : [Member] | Replies : 7
hi i want to insert the excel sheet into database,and retreive the excel sheet data.i want to insert the excel sheet in so many times with new header columns,means for 1st time i want to insert one excel sheet with columns as jan11,feb11,marc11.for 2nd time i want inert the excel sheet having the columns as jan12,feb12,mar12,for 3rd time jan13,feb13,mar13,........etc,.for this what shoul i do?actually i tried this,but am gettiing some other.i did like as foloows....

1)created table with same columns,which is excel sheet have

2)uploaded that excel sheet into table

3)retrieved that data from table

but i dont want like this beacause,when i insert the new excel sheet into database,i want to delete the existing excel sheet,and replace that with new excel sheet,how it is possible ?can any one please help me

manimala


Responses

Posted by: vishalneeraj-24503 on: 11/18/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi, please find below URLs:-

http://office.microsoft.com/en-in/access-help/import-export-and-link-data-between-access-and-excel-HP001095095.aspx
http://forums.asp.net/p/1941634/5535589.aspx?Re+how+to+insert+excel+sheet+into+database+and+how+retrieve+the+data+from+database+
http://www.wikihow.com/Create-a-Database-from-an-Excel-Spreadsheet
http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database.htm

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Allemahesh on: 11/18/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can see the below link:-

http://www.devasp.net/net/articles/display/771.html
https://code.google.com/p/excellibrary/
http://support.microsoft.com/kb/321686
http://www.codeproject.com/Articles/83673/Importing-Data-from-Spreadsheet-XLS-to-SQL-Databas

Happy Coding,
If it helps you or directs U towards the solution, MARK IT AS ANSWER

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Tejamanimala on: 11/19/2013 [Member] Starter | Points: 25

Up
0
Down
hey am not getting this,its not working

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: vishalneeraj-24503 on: 11/19/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi Teja,

What is you are not getting. Please explain properly?

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Tejamanimala on: 11/20/2013 [Member] Starter | Points: 25

Up
0
Down
you posted some of links,in that i didn't find a solution for my problem,my problem is replace existing table columns with new excel sheet column headers....

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Allemahesh on: 11/21/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
See the below link:-

https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/


Happy Coding,
If it helps you or directs U towards the solution, MARK IT AS ANSWER

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vamc on: 12/17/2013 [Member] Starter | Points: 25

Up
0
Down
Click on the below link to find how to get excel data into database.

http://www.dotnetchallengers.com/App_Folder/Content/Articles/Java%20Script/Get%20Excel%20Data%20into%20Dataset/Get_Excel_Data_into_Dataset.aspx

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response