MySQL Forums
Forum List  »  Newbie

How to export Excel worksheet to MySQL DB (with VBA)
Posted by: Cesari Paolo
Date: February 23, 2011 08:26AM

Hello everyone! I have a big problem :)
How can I export an Excel spreadsheet (only a single worksheet) to a remote MySQL database using VBA code? I have always imported a .csv file with phpmyadmin, but in this case I need to automate all the export process from Excel.
So, first I have to create the DB (if not exists), then a table (if not exists) with some fiels in the first row of the sheet (example: |Code1|Description1|p1|Code2|Description2|p2|) and then with an automated process I have to populate the database table.
I hope that someone can help me!

Edited 1 time(s). Last edit at 02/23/2011 08:28AM by Cesari Paolo.

Options: ReplyQuote

Written By
How to export Excel worksheet to MySQL DB (with VBA)
February 23, 2011 08:26AM

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.