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 adodb, CSV, Query, Recordset, TAB | 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 ado, adodb, connection string, connectionstring, localdb, Microsoft SQL Server, SQL Server, sqlncli | 3 Comments

	Patrick O'Beirne, sp… on Dictionary VBA Class upda…
	joanbaptist on Dictionary VBA Class upda…
	officemacro on Free Add-In to profile VBA spe…
	Patrick O'Beirne, sp… on MS Azure Cognitive Services V3…
	Piotro9x on MS Azure Cognitive Services V3…

Tag Archives: adodb

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

ADODB Connection string for LocalDB and SQL Server Native Client

Recent Posts

Recent Comments

Archives

Categories

Meta