Lab Sql

i'm trying to use the code below to copy data from a sql (2008 r2) table to multiple sheets in … Read more Excel Vba Copyfromrecordset Slows When Copying Over 100 Columns

I have a series of three tables which I would like to join together using ADODB in an Excel VBA app… Read more Nested Join In Excel Vba (adodb) Results In "join Expression Not Supported"

Using TADOConnection class to connect to SQL server 2005 db. Having ConnectionTimeOut := 5; // seco… Read more Ado Connection Timeout Problem

This error showed when I tried to select on an empty table in MS SQL Server 2005: 'either BOF o… Read more Delphi - Either Bof Or Eof Is True, Or The Current Record Has Been Deleted

I am getting an 'Object Was Open' error when opening a TADOQuery which returns a large data… Read more "object Was Open" Error Using Delphi, Sql Server And Ado

I am trying to create a dynamic client excel file(s) that is linked to a 'server' master ex… Read more Vba Ado Update Query