Recent content by mattadams84

Many thanks for the response. I will look in to normalisation. As far as creating tables each day there would only be one table that gets created each day, and then deleted the next. The other tables just update the values in the columns each day (via the linked table excel. (there are 80...

Hello, I am a complete newbie to access, i believe the last time i used it was probably in 1997. I am looking for some advice/help. I have created a database that pulls in data from an excel file which in turn is connected to a web API. I have sucessfuly created linked tables in access. I am...