Share via

Convert Excel formulas to SQL language automatically

D N 1 Reputation point
Sep 12, 2022, 2:38 AM

Is it possible convert Excel formula to SQL?

I mean like this site for convert VB.NET to C#.

I have to write lots of complicated excel function in format of SQL function like this: 

=VLOOKUP(D4,Table25,MATCH(ِDATA!AB$3,Table25[#Headers],0))*IF(OR(E4="W",E4="KW"),(2*((G4*VLOOKUP(D4,Table25,3,0))*IF(D4="COF",SUM(H4,I4),MAX(H4,I4))*VLOOKUP(D4,Table25,2,0))+2*(F4*IF(D4="COF",SUM(H4,I4),MAX(H4,I4))*VLOOKUP(D4,Table25,2,0))),0)

and it is very hard and time consuming.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,843 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,502 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 46,376 Reputation points
    Sep 12, 2022, 6:03 AM

    Is it possible convert Excel formula to SQL?

    No, only re-writing them manually. Excel formula and SQL are more then just different.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.