This project is a Data Access layer that can be used in any VBA application to connect to SQL Server. The purpose is to keep database connectivity tidy and core database commands centralized within a ...

There was an error while loading. Please reload this page. The Excel SQL Connector Application is a VBA-based application that allows you to connect an Excel file to ...

I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...