Search results

  1. H

    Are Linked Tables Faster?

    Good afternoon, I won't go into details, but I have an access database which imports tables from another access database, does some stuff (VBA), and exports the data to Excel. Before today, I used to use TranferDatabase acImport, and the process used to take about a hour. I changed this to...
  2. H

    ADO Select Into Query

    Hello, I am trying to connect to an Oracle database using ADO instead of DAO. I am connecting using ODBC, and can connect just fine, but I want to insert the records retrieved by the recordset into a table in my access database. Can anyone tell me how to accomplish this without looping...
  3. H

    Linked Tables - Does Access use ADO or DAO

    Hello everyone, My questions is simple, yet I could not find the answer anywhere. Does Access use ADO or DAO when querying data from linked tables connected through ODBC? Thank you very much in advance.
Top Bottom