Search results

  1. I

    Solved Remove linked excel from Access db

    Hello everyone! I am using the below code to link my Access db to excel and name the linked excel as "Tabelle1". After using the data from excel I want to remove this link and make free Access from excel. How should I do it through VBA ? Thank you for help DoCmd.TransferSpreadsheet acLink...
  2. I

    Look if Access field data available in the Excel file using VBA

    Hello everyone! Iam new to Access programing. I want to write a vba code in Access that looks if field data (available in access user interface) is also available in the excel spreedsheet and then copy the data available on the next right cell of exel to table in the MS Access. Anyone can...
Back
Top Bottom