Hello everyone!
I'm new to Access in general, and I am creating a database for the company I'm with right now. I was wondering if anyone could help me out with this, as I am thoroughly stuck.
We have an outside source of excel formated information that is being consistently updated by a linked table. And we have additional information of the same kind being put into a different table because it isn't from the same source. There is so much data that going through and transferring them all to one table is just not reasonable.
Is there a way to combine them, and then use a form to be able to access/see these reports? Do I need to use a query?
Thank you for your help!