oracle

  1. M

    Power Query get and transform data

    Hi experts, for reporting on e-commerce data I am preparing daily, weekly and monthly reports. The data sits in different databases (Oracle, Google Analytics and numerous third partner platforms). The KPIs needed are: order count, revenue, cost, clicks, impressions. Is there a way to automate...
  2. K

    Connecting to Oracle DB without oracle client

    Hi All, Kindly provide an example to connect oracle database without oracle client installed in system. TIA
  3. K

    Connecting Oracle DB using Oracle.DataAccess.dll

    Hi All, Good Day! I want to know how to connect to Oracle DB without oracle installed on the system. When check in google it was told to use Oracle.DataAccess.dll. But could not do that can any one suggest how to use this dll and connect to oracle db. Using VBA macro. TIA
  4. F

    Excel data matrix into a pivot

    Hi, I need some help to put the following data into an excel pivot so that I can look at any Oracle Role and see only those responsibilities that apply (ie where the X exists - I don't want to see any of blank cells_). Is there a way of doing this? A regular pivot does not seem to...
  5. S

    Copy and paste multiple ws from wb1 to corresponding ws on wb2

    Hi All,I'm relatively new to VBA and am reintroducing myself to it again now after a short hiatus.My current situation sees me compiling and producing reports based on data we get output from Oracle datatbases. Currently we run an Oracle report that contains multiple worksheets and export them...
  6. srizki

    Excel upload to Oracle tab ADD IN tab missing on 2013

    Hi All I had a tab on my Excel ribbon on a template on Excel 2010 . It is called Add-in, it would only appear when I would click any other sheet tab and click back to the Upload sheet tab (upload to Oracle), since I updated my Excel from 2010 to 2013, it does not appear, though it is shown...
  7. E

    Smart View - Connect to a Shared Database

    Hello, I am fairly new to Oracle Smart View and have been recently assigned to debug an issue with establishing a connection to our National Sales connection. Establishing a connection requires logging in with a username and password. How do I properly establish a connection to National...
  8. M

    Create user in Oracle with VBA from cell value

    Hello, Is it possible to create user in Oracle with VBA from cell value? I have defined connections etc., loop to check cells for values and for each cell with some value i need to run create user command in oracle Below lines are not working Dim SqlString As String SqlString = "create user '"...
  9. G

    VBA - ADODB connect to remote Oracle db - "Runtime error '-2147418113 (8000ffff)': Catastrophic failure"

    Hi all, any help very much appreciated, pulling my hair out here!! I am developing an Excel VBA program that I want to connect to a remote Oracle 11g database, run a query, and return the data to Excel. Connection strings and drivers are all OK as far as I know. (see below) It was working...
  10. S

    VBA - Oracle BI 12C SmartView Message Box

    All, Below VBA code I am using to refresh Oracle BI report data in Excel. It is connected to Oracle BI using Smart View. I am able to refresh data using below code. It shows a message once data gets refreshed such as 'Table1 is refreshed', Is there a way to suppress this message...
  11. G

    How to connect to Oracle Database from Excel

    HI We are using oracle database 11g. Widows 8.1 64 Bit OS MS office -2013 32 Bit. We want to connect to database and run a query. Can i save the DB connection password without user entering every time when refresh the data. Can you please provide the required steps to achieve this...
  12. M

    Using VBA for Oracle Essbase

    Hello all, I am hoping to develop an excel macro/VBA to refresh a worksheet through Oracle Essbase. Currently, the macro completes all operations that I have recorded except for the Oracle Essbase refresh, making it essentially useless. If anyone knows how to code VBA or record macros to...
  13. B

    VBA to connect to an Oracle database

    Hi There, I am trying to connect to an oracle database with no success... If I use an SQL tool (Rapid) I have to add the server name. port number and Service name. I have Oracle installed on my PC (Oracle Client 11g and Oracle Client ORA Files). I have goggled about and cannot find a piece of...
  14. srizki

    VBA question, Increase the last row to upload.

    I use a spreadsheet to upload data on Oracle using Add-Ins, but many times there are specific number of rows that are uploaded, let’s say I have 1200 rows to upload, and let's say 587 will upload, whatever I do. The upload sheet has a macro, that says that upload the rows where there is a flag...
  15. M

    Suppressing Oracle Error Message in VBA

    Hi All, I have a macro that refreshes a ton of sheets with Essbase, and for each sheet that I refresh I run into an error saying "Oracle Smart View for Office: Cannot change part of a merged cell." Is there any way I can suppress this error message from popping up? Disabling display alerts does...
  16. D

    Oracle Smart View POV selection

    I may be reaching here, but has anyone who uses Oracle Smart View for Excel discovered a way to use VBA to make a selection in a dropdown in a POV form? Background Info: My company uses Smart View and supplies us with a list of forms we can open. After we open the form, we select a project...
  17. C

    execute oracle query in macro using ODBC

    Hi savers, I want to connect my macro to an oracle database then execute query in macro. This is the import vba that I record: Sub Macro1() ' ' Macro1 Macro ' download schema ' ' With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _...
  18. K

    Updating Oracle Connection Table Closes Workbook

    Hello All, I am using an Oracle connection which was working for some time. But now, doing anything with it closes the Workbook. It just closes there is no warning or message or anything. I am using PowerPivot SP2 Excel 2010 32bit (on Windows 7 64bit). The provider is OraOLEDB.Oracle. The...
  19. J

    Access sql fields to rows with aggregates

    Hi, I have the following scenario: Table1: ID Code Value 400 100 Red 400 101 Green 400 101 Green 400 102 Blue 400 103 Brown 400 103 Brown 400 103 Brown 401 100 Black 401 102 Yellow 401 103 Green The above table has 3 fields: ID, Code and Value When codes appear multiple times for the same ID...
  20. R

    Excel VBA - Oracle SQL Datatype not supported Error

    Hi All, I have been trying to download SQL Scripts through excel. It was successful at first but when I tried to run the below script it prompts a Datatype not supported error. I am using an ADO connection for this. Below is the code to call SQL script. Dim sql As String sql =...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 35
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top