Member Avatar for jbutardo

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

  • 2 Contributors
  • 2 Replies
  • 246 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by jbutardo

Recommended Answers

All 2 Replies

Member Avatar for thines01

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.

Member Avatar for jbutardo

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.