Looking for a JavaEE Architect or Potential Tech Co-Founder?
Please don't hesitate to contact me.

Generate dynamic insert statements in ms excel

Excel is a very powerful tool, you can use it in a lot of things.

For me, I often use it to geenrate dynamic database inserts.

For example you have columns, A, B, C with values name, address and birthday. Then D should have the following formula:


="INSERT INTO employees (name, address, birthday) VALUES ("&A1&","&B1&","&C1&")"
Generate dynamic insert statements in ms excel Generate dynamic insert statements in ms excel Reviewed by Edward Legaspi on Friday, October 22, 2010 Rating: 5

No comments:

Powered by Blogger.