Need a macro that populates statement based on the header

[m_kiran]

Dear Team,

Need a macro which will create a statement based on the header information dynamically and iterate till the last row in the data in excel. Header information wont be static all the time. It changes all the time

[TABLE="width: 500"]
<tbody>[TR]
[TD]emp[/TD]
[TD]ename[/TD]
[TD]dept[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]kiran[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]shiva[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]

Need to generate a excel like below based on the header information. dbname I will give manually not a problem

Insert dbname(emp,ename,dept) values(10,20,50)
Insert dbname(emp,ename,dept) values(20,shiva,30)

It should create the statements based on the number of rows it have in excel.

Appreciate your response.

Thanks,
Kiran

 

[jmacleary]

You don't necessarily need a macro:

Assuming your table starts at A1, then in cell D2 , place the following formula:

="Insert dbname("&$A$1&","&$B$1&","&$C$1&") values("&A2&","&B2&","&C2&")"

Then copy this formula down column D.

Column D will then have the statements you want.

 

[m_kiran]

You don't necessarily need a macro:

Assuming your table starts at A1, then in cell D2 , place the following formula:

="Insert dbname("&$A$1&","&$B$1&","&$C$1&") values("&A2&","&B2&","&C2&")"

Then copy this formula down column D.

Column D will then have the statements you want.

Thank you very much . @jmacleary

I will put it more clear now.

1) I already written a macro which will retrieve the records from different tables and store the values in the excel as provided.
2)I want to insert those values into Teradata . Hence, I want the excel to generate the rows in the format below and iterate until the last row like the solution which you have provided below for inserting .
Appreciate the response.