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

	Patrick O'Beirne, Ex… on Dictionary VBA Class upda…
	Eduardo Estefano on Dictionary VBA Class upda…
	¿Cómo obtener una li… on VBScript to list installed OLE…
	Patrick O'Beirne, Ex… on VBA code for Microsoft Text Tr…
	Arthur on VBA code for Microsoft Text Tr…

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