Archive for May, 2006

Macro to export data from Excel to mySQL

May 5, 2006 by marco · Comments Off
Filed under: Snippets, Tools, mySQL 

I have been struggeling many times to do initial filling of databases for projects – especially if the data is a deliverable of a customer and the database structure is already fixed. So I built a VBA macro that generates SQL statements for creation of tables and data inserts from a given XLS-file. The idea [...]