MySQL Forums :: Newbie :: How to export Excel worksheet to MySQL DB (with VBA)


Advanced Search

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!
Thanks,
PAOLO



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

Options: ReplyQuote


Subject Written By Posted
How to export Excel worksheet to MySQL DB (with VBA) Cesari Paolo 02/23/2011 08:26AM
Re: How to export Excel worksheet to MySQL DB (with VBA) Dmitry Narizhnykh 03/04/2011 03:05AM


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.