I have an SQL Table called AllStocks with 5 columns.
The columns are StockAllId, StockName, StockSymbol, StockPrice, StockDate.
When I open my application I want to update two of the columns from an Excel spreadsheet. I want to update the StockPrice and StockDate.
My Excel book is called ExcelAllStocks and the sheet is Sheet1.
I will add this to the page load event, but I am lost as to how exactly I can read the data from Excel and how to write over the two columns with data currently in them.
I've tried creating a connection to Excel but I'm having no luck.
Help would be appreciated.