adodb

Hi, I am trying to query some data in an excel sheet using the Micosoft.ACE.OLEDB.12.0 it works fine when there are less than 65536 rows of data, however, when there is more than this it bugs out saying that it cant find the object. Any ideas how to get this to work for large data sets. I am...

I am trying to ADODB to obtain a recordset whereby I select records with the following select statement: .Open "SELECT STORE , CASESSTANDARD , CASES9LTR , PCODE , SALE, SDATE FROM " & TableName & " WHERE [STORE] = " & CStr(wsi.Cells(3, 6).Text) & " AND [PCODE] = '" & wsi.Range("A:A").Value &...

I have some modules which contains some procedures which uses a database connection through ADODB. What is the best way to control all these procedures database connections? Can I somehow only write the username, password and such one time and then reuse this in the other modules?

I am trying to use some stored procedures in Oracle. I've tried to use the upload-function with objConnection.Execute "BEGIN upload_from_excel(1, 2, 3 ,4); END;", but I don't know how to get any response if the query didn't run successfully. Is there a way to do this in VBA? I've found that I...

Hi, When I use the ADODB library I know it's required that I've added Microsoft ActiveX Data Objects 2.8 Library before I can use my code. If it's now added my code will return an error. Is it possible through VBA to check if the reference is loaded before my line Dim Connection As...

I've tried to import data with following code With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array("DSN=db_name; UID=user_name; PWD=pw;"), Destination:=Range("$A$1")).QueryTable .CommandType = xlCmdSql .CommandText = Array("SELECT * FROM table") End With...

I am retrieving data from 2 different databases with two different ADODB.Connection objects. Is there a smart way to connect to two different databases? I want to merge two queries from those two databases and print the data with just one CopyFromRecordset. Is it possible? I am using Excel...

Hi, I am using an excel vba macro to get data from others excel files through an adodb connection. There are different source files containing extacly the same kind of data (same column type, same number of column etc), just the number of rows in each file is different. The vba macro works...

Hey Everyone, In my workbook I am trying to connect to a local server using an ADODB conneciton referening the activex data objects 2.8 lib. I am using code that I copied from an old project of mine that works just fine, however it is not working when I modify it to use (local) as the server...

Hi, First of all let me preface this with: I've tried hard to find the answer to this myself, so I'm sorry if this already exists on the forum. I'm trying to do a mass import into access using the OLEDB driver and "fixed width" if you notice in the below code, the commented out part is what I...

Hello, diving into cross access/excel stuff here. Well, not really, but I'm using disconnected ADO Record Sets to index my massive worksheet tables (30,000+ rows). The whole thing runs beautifully. However I now want to be able to merge/pull/export/import different 'Data' sheets around, so for...

Ello I have a disconnected ADODB, which userforms access. To search for items to perform actions on, there are 2 comboboxes. The first is my custom 'UniqueID' string ("AAAAA, AAAAB, etc"). The second is has two columns, the first is the Unique ID again, the second (which is ALSO THE BOUND...

I have a strange problem. I am using CopyFromRecordset to paste some data from a database, then formatting the data. The first column includes a date, so it comes in as a Julian value, then I format it to mm/dd/yyyy. This is on Sheet1. Then, I use CopyFromRecordset for another select...

Querying an Access database using the values in a range in excel. See i have some values in say column A of sheet1. I have to use these values to Query an Access database. I am trying to connect to the database using ADODB. Another thing is that, I tried to use the SQL IN command to query...

I have a table of ref data which I connect to using ADODB (Code is below) Where .Fields(9) is Text it is returned, but when it's numeric it is not. I've tried removing null and making them all numeric but still have had no joy. I'm sure this is something to do with Types, but for the life of me...

I'm still having issues with an Excel spreadsheet with macro's... to make it multi-compatible for Office & Windows versions. In particular for ADODB in 'Microsoft Active X Data Object #.# Library' (C:\Program Files\Common Files\System\ado\msado*.dll) & mscomct2.ocx. I developed it in 2010 & am...

Hi folks, Do any of you know of a good tutorial for making use of ADO to connect to a SQL database? My search of these forums didn't return any results... which is unusual! :) Thanks, Dan