Recent content by AccessAggrieved

Hello and thanks for your response. I twisted my mind, but thanks to you i realized that this problem is actually not that hard. Here is what i'm gonna do: I will import the excel file as linked table. An update query will set the validTo-date for all records that have the same key values and...

Hi there, I am pretty new to Access, VBA and the like, and i need your help. I need to implement an import function to import data from various excel sheets. I would be able to delete the old content und import the new data via DoCmd.TransferSpreadsheet and SQL, but in this case all changes...