from Excel to Database
-
Hi, I want to export some data from an Excel file to a Database. How can I connect programmatically to Excel? How can I export from Excel to Databse?
I suggest you do a search for excel on codeproject. I found lots of useful articles on CP about this. I cannot remember the name of the article, but there is a good one on connecting to Excel using ODBC which I think will help you a lot, as you could load this information into a dataset, then connect to sql, etc.
-
I suggest you do a search for excel on codeproject. I found lots of useful articles on CP about this. I cannot remember the name of the article, but there is a good one on connecting to Excel using ODBC which I think will help you a lot, as you could load this information into a dataset, then connect to sql, etc.
-
I dont know, I did a search and came up with a lot to do with Excel. But here is the address anyway: www.codeproject.com/csharp/Excel_using_OLEDB.asp