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 y...
https://www.czetsuyatech.com/2010/10/generate-dynamic-insert-statements-in.html
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:
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&")"
Post a Comment