adodb

  1. S

    Check if ADODB reference is added

    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...
  2. S

    ListObjects.Add ADO

    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...
  3. S

    Merge queries for different databases

    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...
  4. C

    ADODB connection problem because too many rows in source file?

    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...
  5. M

    ADODB Local Server Connection

    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...
  6. A

    ADODB Import fixedwidth - no value given for required parameters

    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...
  7. ClimoC

    Save xls sheet or RS to mdb?

    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...
  8. ClimoC

    Userform Combobox - Link to Index of Unbound Column?

    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...
  9. J

    Formatting from CopyFromRecordset

    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...
  10. W

    Querying an Access database using the values in a range in excel.

    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...
  11. G

    EXCEL VBA ADO Recordset Problem

    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...
  12. S

    Coding for diff versions of "Microsoft ActiveX Data Objects" Library

    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...
  13. D

    Using ADODB to connect to a SQL database

    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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top