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..

Recommended Answers

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.

Jump to Post

All 2 Replies

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.