Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vijer
  • Order by date
  1. vijer

    Connecting to Access and updating a table from Excel

    Unfortunately when I try to run this code I get the error message "User-defined type not defined" and the Excel VBA editor highlights the dim statment Dim Mydb As database I have also tried Dim Mydb As ADODB.Connection and get the same error message I am running...
  2. vijer

    Connecting to Access and updating a table from Excel

    I would like to modify a QueryTable and update the Access database the recordset came from. Is this possible and if so what is the best method to accomplish this? Thanks
  3. vijer

    Excel and Access Connectivity Problem

    I would like to modify the results of a Excel TableQuery and then update the original Access database. Is this possible and what would be the best way to go about it?

Part and Inventory Search

Back
Top