I have table relationships between two different Excel import files, which are now tables within the Access database through a Form code I created that can browse and import Excel files automatically into Access Tables.
What I am wanting to do however, is be able to save a new version of each of these two Excel import files that overwrite the previous two into my database once a week that will automatically contain the table relationships - is this possible?
Or, is there a way to VBA code and save a relationship instruction, so that if I delete the two files once they are a week old for example, then import the two newer versions with exactly the same file names, that code could then perform a new relationship which is identical to the the last relationship between those two tables?I'm just aware that when I delete one or both of the tables, the relationships obviously break, then when I import the newer files, obviously at the moment I'm required to create new table relationships.Hope the above makes sense, and any help would be appreciated massively.
Kind regards
Samuel