How to Fetch data from Excel and how to store data to sql server database

Posted by Kummee under Regular Expressions on 6/7/2011 | Points: 10 | Views : 4108 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi All,

I have an Issue. I am doing a project. In that I have one excel File with .csv extension. I want to retrieve the data from an Excel File
and store that data in to sql server data base through front end as asp.net and C#.

Any body Help me.

Thanks in Advance

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Nithadeepak on: 6/7/2011 [Member] Bronze | Points: 25

0	http://support.microsoft.com/kb/319951/EN-US/ http://blog.dotnetsquare.com/net/import-data-excel-sql-server-aspnet/ http://www.codeproject.com/KB/database/Excel2Sql.aspx http://forums.asp.net/t/1365129.aspx/1 Nitha Deepak Kummee, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Susanthampy on: 6/7/2011 [Member] [MVP] Bronze | Points: 25

0	Hi, Refer this links, http://www.builderau.com.au/program/sqlserver/soa/How-to-import-an-Excel-file-into-SQL-Server-2005-using-Integration-Services/0,339028455,339285948,00.htm http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html Regards, Susan Kummee, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vforvijay on: 6/7/2011 [Member] Starter | Points: 25

0	hi...try this link for getting data from excel and store into DB http://vbdotnetaddict.blogspot.com/2011/01/import-excel-table-into-sql-table.html Kummee, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts