C# connection with Excel

lankapala used Ask the Experts™
Hi, I need to write C# programme to connect with excel not ODBC. See attached screnshot
after write C# programme ability create connection.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

That is connecting excel to a database, not connecting to excel.
Software Team Lead
it would be probably easy to connect to excel using an OLEDB Data Object Library.

you can refer to this article for more info.

Read Excel file using OLEDB Data Provider in C# .Net

so, treat your Excel as a data source.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial