Tag Archives: adodb

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

Posted on Jan 18, 2021 by Patrick O'Beirne, Excel/VBA developer

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, Excel/VBA developer

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

	meddy freeman on VBScript to list installed OLE…
	Patrick O'Beirne, Ex… on Dictionary VBA Class upda…
	Ratrack on Dictionary VBA Class upda…
	Power Query infer da… on Querying Text/CSV files in VBA…
	Patrick O'Beirne, sp… 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