• Connecting to SQLServer VBA

    Connecting to SQL Server in VBA Excel

    Building automated reports in Excel by connecting directly to an ERP database is a good shortcut to have fresh and accurate information to base your decisions on. This method facilitates data processing and manipulation in VBA before results and conclusions…