no

How to Generate Dynamic Sql 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...

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&")"

Related

rdbms 1048623578554482900

Post a Comment Default Comments

Outsourcing

Are you looking for freelancers in the Philippines? Get in touch.

Donations

If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.

item