Hi,

I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data.

Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection is the most possible way to open it?

Thanks..

No, you cannot use the MySQL connection to open an Excel file.
You can use OleDB or ODBC or COM to open an Excel file.

No, you cannot use the MySQL connection to open an Excel file.
You can use OleDB or ODBC or COM to open an Excel file.

Okay, thanks.. case closed

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.