Export Excel sheet data to csv format

Question

I am storing my employees data in excel sheet i have developed a application where i can import csv file now i need to convert my excel sheet data to csv format so that i can import it to my application.I'm using microsoft office excel 2007 to store my data.

can any1 help me on this

Sam Hobbs · Answer

An alternative solution would be to have Excel put the spreadsheet data into a SQL Server table or to have SQL Server do the transfer. I don't know ther details of how to do it but I am sure you can do either one.

Sweety · Answer

I'm getting error like this Error 1 'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Excel.DataTable' E:\Excel data to csv\csv\ConsoleApplication1\ConsoleApplication1\Program.cs 17 13 ConsoleApplication1

Jiteendra Sampathirao · Answer

hi Refer this Link