+ Reply to Thread
Results 1 to 3 of 3

VBA - Updating Excel values to a Database

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2016
    Posts
    110

    VBA - Updating Excel values to a Database

    Dear all,

    I need your help in writing a Macro to update a Oracle SQL database based on the values in an excel sheet.

    Please assume the Oracle database details as below:
    -------------------------------------------
    Hostname : 1.2.3.4
    Port : 1234
    SID : DBUPDATE
    Username : abc
    Password : abc
    --------------------------------------------

    Table Name : employee_details

    Table details:

    emp_id, emp_name
    1 -
    2 -
    ---------------------------------------------

    The content of excel sheet are as follows:

    emp_id emp_name
    1 a
    2 b

    ----------------------------------------------

    Could you please help with the VB Script to update emp_name in Oracle database based on entries in the excel sheet?

    Thanks,
    Vinod Krishna
    Attached Files Attached Files
    Last edited by Vinod Krishna.C; 05-19-2014 at 09:09 AM. Reason: Oracle database

  2. #2
    Registered User
    Join Date
    09-13-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: VBA - Updating Excel values to a Database

    check this thread...


    http://www.excelforum.com/excel-prog...e-help-me.html

  3. #3
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2016
    Posts
    110

    Re: VBA - Updating Excel values to a Database

    Hi Vaibhav,

    Could you please help with the following:

    * Downloading the latest Oracle ODBC Driver - Where should the driver be placed?

    * Change the settings below and select the proper driver [from the following part of code]:
    '----------------------------------------------------------------------------------------
    'Initiate database connection
    '------------------------------------------------------------------------------

    'Specify your driver below
    Please Login or Register  to view this content.
    Thanks,
    Vinod Krishna

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Updating dynamic data into excel database
    By mantooth29 in forum Excel General
    Replies: 1
    Last Post: 10-21-2011, 12:06 PM
  2. Auto updating of Database in MS-excel 2007
    By Renildrah in forum Excel General
    Replies: 0
    Last Post: 08-04-2011, 03:31 AM
  3. Updating a range of values in a mySQL database
    By billiboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2008, 07:32 AM
  4. Updating Excel forecasts into an Access Database
    By Maree Maxfield in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2005, 12:00 PM
  5. [SOLVED] updating database from excel
    By mangyan73 in forum Excel General
    Replies: 0
    Last Post: 11-07-2005, 11:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1