The Excel SQL Connector Application is a VBA-based application that allows you to connect an Excel file to a Microsoft SQL Server and manipulate the data using a user-friendly form. Before using the ...

VBA: Connection string results in "External table is not in the expected format" ... today I had to update a C# app I wrote 3 years ago that reads in an Excel file into a SQL Server table.