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

Re: Opening excel file in vb.net 80 80

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.

Re: Opening excel file in vb.net 80 80

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