Search results

  1. T

    Update Access table with weekly Excel exports

    ok.. i figured from available query ribbons that i could do update / append when i have small amount of tables. i already have a half years worth of excel files and need an automated / scripted solution. where i'd loop over the files in the directory and digest them in order.
  2. T

    Update Access table with weekly Excel exports

    Hi, I use the serial numbers of the respective items as primary key.
  3. T

    Update Access table with weekly Excel exports

    Hi forum members! I am new to Access, have searched the web for the last couple of hours and don't seem to get anywhere. Basically I have an inventory system that is neglected by IT. To answer certain questions I import parts of that system in my own Access DB to forge away with my queries...
Top Bottom