Genrate SQL Queries from Excel

Using excel operator ‘&’ to generate SQL query

Once the data is ready it is very easy to generate the SQL queries using excel string addition operator – &. For the above tabular structure, the concatenate formula would look like:
="insert into customers values('" &B3 &"','" & C3 & "','"&D3&"');" where B3, C3, D3 refer to above table data.

No comments:

Post a Comment

Pages