Item #4 of the above link states that it is not intended for "
... a program called from server-side web application such as ASP.NET ...
So what is the preferred method to access data stored in Excel for an ASP.NET application ?
I understand that you don't want to build an OLTP system usign Excel as a datastore ... but I have a situation where there is a spreadsheet which is updated by one department and I was thinking of buidling a simple webpage which would be used as search front-end for folks who do not have "edit" access to the Excel doc. Should be OK? Right?
If I recall correctly in Win7 Ole JET DB is deprecated and you should use mentioned ACE.OLEDB.12.0. For older systems use JET. This should be installed with office and one of them should be accessible. In my app I use web.config connection: jet for production with older version of WinServer and OLEDB for my Win7 dev machine. I don't know if there is better way.