Use excel file as a database using C#

Question

Hi  I would like to know how we can use excel file as database using c# . It mean c# will be front end and excel will be back end. I need one simple program with step by step so that i can follow that. Please help Thanks in advance.

Upendra Pratap Shahi · Answer

Hi go through below link- http://www.c-sharpcorner.com/Blogs/49753/using-excel-as-database.aspx

Amitesh Verma · Answer

http://www.c-sharpcorner.com/Blogs/49753/using-excel-as-database.aspx

Rajeesh Menoth · Answer

Hi Read this below articles : 1) http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/ 2) http://forums.asp.net/t/1207592.aspx?how+to+read+data+from+excel+and+insert+into+SQL 3) http://www.codeproject.com/Articles/19801/Fetching-Data-from-Microsoft-Excel-using-SQL 4) http://www.codeproject.com/Tips/147331/Reading-Excel-file-in-SQL-Server

Amitesh Verma · Answer

http://www.codeproject.com/Articles/1155/Simple-ADO-NET-Database-Read-Insert-Update-and-Del