473,513 Members | 2,378 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Excel to oracle

82 New Member
Does anyone know a good website for more complex examples of excel formulas and their sql query equivilents? I have searched the net and only seem to return downloads for converters. Any help is appreciated.
Aug 4 '09 #1
3 2811
starlight849
82 New Member
More specifically I have an excel formula such as this:
SUMPRODUCT(('Apple'!$A$2:$A$5000<>"")*('Apple'!$K$ 2:$K$5000>'Orange'!$I$1)*('Apple!$L$2:$L$5000<>"") )
How can I convert this into a single query? Or will I need to use multiple query?
Aug 4 '09 #2
amitpatel66
2,367 Recognized Expert Top Contributor
It would be great if you can break up the formula and explain the different columns used and from which table it comes from in a database?
Aug 5 '09 #3
starlight849
82 New Member
SUMPRODUCT(('Apple'!$A$2:$A$5000<>"")*('Apple'!$K$ 2:$K$5000>'Orange'!$I$1)*('Apple!$L$2:$L$5000<>"") )
'Apple'!$A$2:$A$5000<>"" this is the order number
'Apple'!$K$ 2:$K$5000>'Orange'!$I$1 k = the scheduled finish and i is the user entered date that user will enter from a vb.net front end.
'Apple!$L$2:$L$5000<>"") is the actual finish of the project

I will be pulling all the information from the same table in the database, minus the user entered date.
Aug 5 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

10
5947
by: Robert Hicks | last post by:
I need to pull data out of Oracle and stuff it into an Excel spreadsheet. What modules have you used to interface with Excel and would you recommend it? Robert
3
7565
by: hkappleorange | last post by:
I connect to mdb file using the following codes. How should I modify it if I want to connect to Excel instead ? <%@ Import Namespace="System.Data.OleDb" %> <% Dim conAuthors As...
5
20705
by: Joper | last post by:
Hi, I'm getting the ORA-00911:invalid character when trying to do a query to a Oracle database from a Excel VBA Macro. I'm using the following code extraction: ----BEGIN CODE----- Sub...
3
14923
by: jelinjose | last post by:
Hi, I have created a table with table name T1 with a particular schema. I have entered the data in an excel sheet in the particular schema above and saved as T2.dmp file. I would like to know...
3
2705
by: newtechiebug | last post by:
I am really new with Perl and I am trying to write data from an Oracle database to an Excel Spreadsheet simply by clicking on a link. I have read over CPAN Spreadsheet::WriteExcel and I really am...
1
1432
by: Userdom | last post by:
Hi, I need to charge the list of employees from excel sheet that I Have in C:\ directory to oracle table and I need to do this every day at specific hour is like insert and update from excel to...
3
2035
by: peteh | last post by:
Hi All; I have tried to find this info on the IBM site, but alas... We are running DB2 v9.1.1 and making extensive use of Information Integrator (now known as Websphere Federation Server?!) to...
1
5038
by: =?Utf-8?B?Y29uc3RhbnRpbg==?= | last post by:
I have problem with my code I need to read from Excel worksheet into dataset the problem is in this line oleda.Fill(ds). The data adapter should fill dataSet with data from Excel worksheet but...
0
940
by: =?Utf-8?B?Y29uc3RhbnRpbg==?= | last post by:
How to build an array to make it easy to read the data from Excel worksheet table then load the data into oracle.The table looks like this have 4 columns:1-entity name with two...
0
2780
by: gjones | last post by:
I have an Oracle Forms application and I want to populate an Excel spreadsheet with some data from the application. I am using the DDE.Poke command to transfer data into the spredsheet and that is...
0
7267
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7391
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7553
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7120
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7542
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4754
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1609
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
809
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
466
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.