Connecting Tech Pros Worldwide Forums | Help | Site Map

Excel to oracle

Newbie
 
Join Date: Jun 2009
Posts: 6
#1: Aug 4 '09
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.

Newbie
 
Join Date: Jun 2009
Posts: 6
#2: Aug 4 '09

re: Excel to oracle


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?
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#3: Aug 5 '09

re: Excel to oracle


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?
Newbie
 
Join Date: Jun 2009
Posts: 6
#4: Aug 5 '09

re: Excel to oracle


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

Tags
sql excel oracle