Opening excel file in vb.net

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

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

[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