oracle

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...

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 =...

Facing an issue with statements received on monthly basis. The period from 01-12 of days are considered as months, no issues with the period from 13-31. No matter which format i select, i still face same problem. Resulting me to enter the dates manually to fix it. <tbody> # Date 1...

MS Access 2003 Oracle 10g Windows 7 I am basically running data updates every night into local MS Access tables from source data tables in Oracle. This worked fine, until some change on the network which produced a timeout error for all append queries that used pass-through queries. In order...

Apologies if this is more of an Oracle question. I wish to load a table with more than 1 million rows to an Oracle database. The data is provided to me in separate Excel spreadsheets, each with less than 1 million rows. I may be able to get the supplier to fit all of the data in one...

Hello, I am trying to import an Oracle RDB Recordset to Excel via Microsoft VBA. I currently have a working SQL string but would like to return just the top 1000 rows. Normally I would use "SELECT TOP 1000" for an SQL Server. I understand that this will not work for Oracle, so I tried Oracles...

Hi All, I have a requirement of building reports using Oracle functions in PowerPivot. My Oracle functions are like below: CREATE OR REPLACE TYPE <DATABASENAME>.obj_Inactive_Cases AS OBJECT ( STATUS VARCHAR2(30), SUB_STATUS VARCHAR2(30), CNT NUMBER(12) ) / CREATE OR REPLACE...

I have a query in VBA code, to pull data from an Oracle database into Excel. That code works fine, but I have to prompt the user for their username and password every time they run the query, to authenticate them to Oracle. The user's Active Directory credentials and their Oracle database...

Hey ho I'm trying to move part of an Oracle table-view into a new Access(2010) table. I tried linking the table with an ODBC connection from Access - but the Oracle table is both too large for Access to handle, and Access also ended up jamming the server and p*****g off the Oracle DBAs. I...

Hello all, Is it possible to connect to Oracle server with VBA when the excel application and Oracle resides in different servers? I should mention the server where the oracle resides needs it own authentication. So I need to use a kind of connection to the server with supporting authentication...

Howdy How Just getting into more SQL heavy orientated stuff to work things a bit smarter and faster when I then start vba/excel'ing with my recordset The datatype on the server (PL/SQL Oracle), like a lot of them, is in text format so after reading up on the CAST function, I can successfully...

I have several VBA applications that interface with Oracle databases. Up to now we've been using ODBC, DAO (via the DAO360.dll library) and ADO (MSADOnn.tlb) to get to them using a connection string that names the Oracle database server, the userID and the password. The oracle clients and...

I have several Access/VBA applications that interface with Oracle databases. Up to now we've been using ODBC (via Access links), DAO (via the DAO360.dll library) and ADO (MSADOnn.tlb) to get to them using a connection string that names the Oracle database server, the userID and the password. The...

I have several spreadsheet/VBA applications that interface with Oracle databases. Up to now we've been using ODBC (via Excel queries), DAO (via the DAO360.dll library) and ADO (MSADOnn.tlb) to get to them using a connection string that names the Oracle database server, the userID and the...

Hello, One of my engaging tasks at work is to disable/enable general ledger accounts (accounting speak) in our Oracle ERP application using one of their forms. In this case it would be a list of gl accounts and to the left of the gl account would be a check box that I can click. Checked...

Hi, I have a scenario where in i need to connect to Oracle and get data from a table which contains CLOB datatype value. Below is my code: Dim ConnectionString As String Dim SQL_String As String Set con = New ADODB.Connection Set recset = New ADODB.Recordset Oracle_Data_Source = "perf01"...

I created a spreadsheet that is connecting to an Oracle database using ADO. A user's copy started to fail to connect after an Oracle upgrade, giving a message "TNS no listener". How can I find the path used by Excel for the tnsnames.ora file?

I am looking in a VBA project I've downloaded and have found following code SQL = "BEGIN budget_p.upload_from_excel(" & ... & "); END;" I've looked through the entire project for the names "budget_p" and "upload_from_excel", but can't find anything. The project is helping me update and...

I connect to an Oracle database by the code below. Is it possible to improve the code? What could a function which returns data based on a ID in a Excel sheet look like =getName(id)? Is it bad syntax to make a function with a sql string-parameter like =getValue("SELECT * FROM db WHERE Id = id")...

I Have a workbook which consists of 50 worksheets and i use Edit query window to pull the data from oracle on all these sheets. We run this once in a month. I have to go to every sheet and execute this code which is time consuming and i have to change the date value everytime.Please help me with...