Top "Adodb" questions

'Type Mismatch' Error on ADODB.Recordset

I have a program that is supposed to read data from an SQL database and report back to Excel. It …

excel adodb recordset vba

Excel table loses number formats when data is copied from ADODB recordset

I'm updating an excel table from an ADODB recordset using the CopyFromRecordset method. After the update, the numbers show up …

vba excel adodb

HOWTO: Open an ADODB recordset from a command object that allows updating?

In the following code, I try to open a recordset using ADODB from a Command object, but it tells me …

ms-access ado adodb recordset

Running multiple async queries with ADODB - callbacks not always firing

I have an Excel workbook that fires three queries to a database to populate three tables on hidden sheets, and …

vba excel excel-2010 adodb

Windows Script Host (jscript): how do i download a binary file?

i'm trying to automate a file download with Windows Script Host (JScript). i see ADODB.Stream has an Open method …

adodb wsh jscript

Passing current ADO Record to another function

Perhaps I've spent too much time in .NET, but it seems odd that I cannot easily pass the current Record …

vba vb6 adodb

Deep Copy or Clone an ADODB recordset in VBA

I have been searching for a way of duplicating or copying a recordset in VBA. And by that I mean, …

vba excel adodb recordset

ADODB COM object not found

I am using ADODB COM object in my c# application which is developed on Windows 2008 R2 Standard 64bit. Now I …

c# windows-server-2008-r2 adodb mdac

How do I return a ADODB.Connection from a function in VBA?

I have recently started working with another programmer on a large Access VBA/SQL Server application. In each function there …

sql-server ms-access database-connection vba adodb

Named variables in SQL using ADODB in vba

I have lots of SQL scripts, many of which use various different variables throughout, and I'd like to be able …

sql sql-server excel vba adodb