Archive

Archive for the ‘excel’ Category

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.

  1. Select cells
  2. Hit add-in
  3. Enter table name

Done.

Advertisements
Categories: excel, tech