MySQL Forums
Forum List  »  MySQL for Excel

Re: MySQL for Excel
Posted by: Javier Treviño
Date: June 09, 2014 10:38AM

Hi Michael,
Thanks for writing in our forums!

With MySQL for Excel you will be able to insert data from Excel to a MySQL table, but NOT programatically through VBA. MySQL for Excel is a high-level friendly tool to manipulate MySQL data through Excel in a friendly way.

If what you need is to be able to insert Excel data into MySQL in a customized way that suit your needs using VBA then you should use MySQL Connector ODBC to then establish a connection through it (using an OLE ODBC provider) so your VBA code opens a connection and does all the work.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
2442
June 05, 2014 08:14AM
Re: MySQL for Excel
1727
June 09, 2014 10:38AM
1418
August 25, 2014 10:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.