How to insert data from an excel sheet into a database table??

Question

Hi,

I need to insert the data from an excel sheet into a teradata table. and I need this to be done using a MACRO.

I have data in an excel sheet like

COL1  COL2 COL3 COL4
1      2    3     4
2      5    8     10
.
.

so on

and i need to keep a button in the excel sheet and assign a macro to that button so that when i click the button the rows in the excel sheet should be inserted into a database table.

The requirement is that I will send the empty excel sheet to the person, he will fill in the sheet with the data and he clicks the button in the excel and the data has to be inserted into the database table. I would prefer doing this using a macro..

Thanks all.

Answer 1

Have a look at this link for using vb/vba code (for the marco) to move data from excel to sql server.