Home > excel, tech > Excel macro to MySql code

Excel macro to MySql code

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
  1. December 13, 2007 at 10:42 pm

    You can start with this code. Check out the one comment – it sounds like a pretty good idea that could still be automated.

  2. December 13, 2007 at 10:42 pm
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: