Here is the relevent code: Code: Set ConnFile = New ADODB.Connection ... app I wrote 3 years ago that reads in an Excel file into a SQL Server table. I'll make some assumptions here: Based on ...

While Power Query is a fantastic option for transforming ... macro workbook serves as a centralized repository for storing VBA code that you want to use across all Excel workbooks.