Tag Archives: adodb

Querying Text/CSV files. Method #2: ADO Recordset

Posted on Jan 18, 2021 by Patrick O'Beirne, spreadsheet auditor

The module ADOQueryText.bas has the functions to read a delimited text file into a worksheet. It uses an ADODB recordset to perform the query. Continue reading →

Posted in Excel/VBA | Tagged , , , , | Leave a comment

ADODB Connection string for LocalDB and SQL Server Native Client

Posted on Jul 11, 2014 by Patrick O'Beirne, spreadsheet auditor

The limit on Access MDB file size is 2GB. To get around that I wanted to try out the lightweight LocalDB server, rather than SQLExpress. SqlLocalDB.msi is 38MB sqlncli.msi is 3MB for win32, 5MB for win64 It took a while … Continue reading →

Posted in Excel/VBA | Tagged , , , , , , , | 3 Comments