13 thoughts on “Connect Excel to Oracle Database

    nisha jagtap

    (February 15, 2020 - 12:29 am)

    what if we want to insert more rows in oracle and it should also being updated in excel sheet without refreshing it every time

    Trustworthy System

    (February 15, 2020 - 12:29 am)

    Hello, this is a great video.
    For latest version as EXcel 2016; try these steps (Sorry I translate from french) : Data >> New Querry >> With other sources >> With ODBC >> (your name of Database appears) >> Enter your user name and password >> Choose a table >> choose Load in >> Current sheet or new sheet excel. >> Click refresh All in the menu bar

    Naresh Kumar

    (February 15, 2020 - 12:29 am)

    how we can connect a oracle web application to excel?

    elisha vandeventer

    (February 15, 2020 - 12:29 am)

    What version of Excel? Many of the options shown such as the Data Connection Wizard do not appear for me. I have Excel 2016.

    Ali Raza

    (February 15, 2020 - 12:29 am)

    how to connect excel to oracle cc&b

    Scott Ridings

    (February 15, 2020 - 12:29 am)

    Great video! Thanks for the information. I will be able to do a lot with this.

    Devart

    (February 15, 2020 - 12:29 am)

    There is already Excel add-in for Oracle which easily connects to Oracle from Excel.
    Free for download https://www.devart.com/excel-addins/oracle.html

    james flowers

    (February 15, 2020 - 12:29 am)

    Why not create a profile on oracle and only grant access to the views you want , that way you don't see all the tables .
    Good tutorial.
    Well explained

    Bill Brasky

    (February 15, 2020 - 12:29 am)

    I'm running Oracle on my desktop and trying to link to excel. I'm having problems figuring out what the server name should be. Can someone point me in the right direction?

    Tanmay Garg

    (February 15, 2020 - 12:29 am)

    How can I get some specific rows. Say output of a SQL query. 

    Lauren

    (February 15, 2020 - 12:29 am)

    I love your video, it is very helpful. Is this possible to update Oracle from Excel? For example, I tried to insert a new row in Excel and save it, but when I opened Oracle, the new row is not in Oracle database. I am very curious if updating Oracle database using Excel is possible. Do you know anything about this?

    KAMRAN KERİMOV

    (February 15, 2020 - 12:29 am)

    Nice.
    i have i question
    how you create  the refresh button?

    Duarte Goncalves

    (February 15, 2020 - 12:29 am)

    hi

    Good tutorial.
    I have a question …
    In my excel I do not have the Provider for Oracle.
    How do I acquire the provider for Oracle?

Leave a Reply

Your email address will not be published. Required fields are marked *