Excel macro to MySql code
December 12, 2007
2 comments
I had an idea for a little Excel macro today. I needed to take a set of data from an excel sheet and insert into a MySQL database. It would be great to have an excel add-in that could take the highlighted cells as input and generate an insert statement for each row, and of course doing a little magic of just quoting non-numerics.
- Select cells
- Hit add-in
- Enter table name
Done.