I am trying to fetch data from my oracle db using excel VBA. I have made the connection and successfully fetching the data, however my data containing japanese character is broken. It became something like "A14 ｿｿ: ｿｿｿ ｿ ｿｿ: ｿｿｿｿ (ｿｿｿｿｿ)"
I wonder why my data containing japanese character is...
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...
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.
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...
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...
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...
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...
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 '"...
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...
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...
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...
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...
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...
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...
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...
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...
I want to connect my macro to an oracle database then execute query in macro.
This is the import vba that I record:
' Macro1 Macro
' download schema
With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _...
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...
Hi, I have the following scenario:
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...