-4

I have a requirement. I have an excel report with 5 sheets and I want to send a range of values (for example : values from cell E20:E40) ,( E70: E90 ) )from excel report sheet 3 to my local database table(oracle). Can anybody help to write some code in vba.

Thanks in advance .. ARUN

Improve this question
2
  • Welcome to Stack Overflow! Please take the tour and read How to Ask to learn what we expect from questions here. Please be aware that we do not provide from-scratch coding service here. Please show us what you've tried already, how it failed and we might be able to help. Commented Mar 23, 2016 at 9:38
  • Put this formula ="INSERT INTO table_name ( column_name ) VALUES ( "&E20&");" into F20 and then copy/paste down into F21:F40 and F70:F90 (or any empty column) then copy the output of those cells and paste it into your SQL client. Commented Mar 23, 2016 at 12:08

1 Answer 1

Reset to default
0

There are many source there, do some self learning first then come with the problem you face.

http://www.encodedna.com/excel/copy-data-from-closed-excel-workbook-without-opening.htm

Excel VBA connect to remote Oracle DB with InstantClient

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.