Do you have any tricks for generating SQL statements, mainly INSERTs, in Excel for various data import scenarios?
I'm really getting tired of writing formulas with like
="INSERT INTO Table (ID, Name) VALUES (" & C2 & ", '" & D2 & "')"
Do you have any tricks for generating SQL statements, mainly INSERTs, in Excel for various data import scenarios?
I'm really getting tired of writing formulas with like
="INSERT INTO Table (ID, Name) VALUES (" & C2 & ", '" & D2 & "')"
The semi-colon needs to be inside the last double quote with a closing paren. When adding single quotes around a string, remember to add them outside your selected cell.
(spaces added for visibility - remove before inserting)
=CONCATENATE("insert into table (id, name) values (",C2,",' ",D2," ');")
Here is another view:
=CONCATENATE("insert into table (id, date, price) values (",C3,",'",D3,"',",B3,");")