Hi all,
I am very new to Access, and was hoping you could help me with this.
I want to create a few smaller standalone access databases that exports data to a master database (saved in a different location), which again can generate reports based on the data from all the smaller databases. I have tried the normal import/export function, but my issue is that this creates a new table in the master database. I would like all the data from the smaller standalone databases to be collated in the same table in the Access database.
I would also like the main database to be updated automatically whenever one of the smaller databases is updated.
Any help on this would be really appreciated.
Thanks!