Hello
I am creating a database and need some guidance please.
I have never used access before but have been reading and watching videos to prepare to build a database.
Here is what I am trying to do.
I need multiple excel tables to fill out a database (at remote locations not on the same server) that can be access and merged into central database at my office.
The excel sheets will be changed out frequently but I need the database to record historical data from excel sheets that are no longer linked or available.
If I have 4 different excel sheets do I need 4 different tables in access that will need to be unioned? or is there a way (vba/sql) to have each row (table design will be identical) or table update without overriding previous data?
Any suggestions on where to start researching ways to accomplish this is greatly appreciated. I really don't know where to start.
Thank you
Jake