current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite
1

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.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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

share|improve this answer
    
I got the code to connect to SQLServer. but i want to do the same for the Teradata database.. –  identifymecnu Oct 15 '09 at 7:32
    
ok then, how about this 209.85.229.132/… –  astander Oct 15 '09 at 7:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.