2 posts tagged with "Excel"

ERPL started as a DuckDB extension for SAP. That's still its center of gravity. But over the past few months it grew arms — into Microsoft 365, into Microsoft Dynamics 365, into the rest of the modern enterprise data surface.

Today's update to erpl.io makes that official. The landing page now reflects what ERPL has quietly become: a SQL gateway to your whole enterprise stack.

Summary​

• The article guides on integrating Excel with Parquet files using DuckDB, highlighting the efficiency of DuckDB for large data sets and how it surpasses Excel's normal data handling limits.
• It includes step-by-step instructions for installing the DuckDB ODBC driver, configuring Excel, setting up the ODBC connection, and suggests using Power Query Desktop for data transformation.