Greetings Access Wizards,
Ive run into a little bit of a pickle when working with linked tables. I'm trying to create a system that take the information from our payroll system and inputs it into access so we can create easy to read reports. I've wrote a python program that coverts the output of the payroll program into a readable .xlsx of (Project Number, Project Name, Hours Budgeted, Hours Spent, Due Date). The program I wrote will update existing project's hours and due date and will add projects that are not currently on the worksheet. I was hoping to just use the excel document as a master table and through an access form add the project manger and any employees attached to each project. However you cant seem to modify or add data to an excel document from access.
Is there a work around to this?
Can I somehow have a local access table update to match from the excel worksheet without duplicating project numbers while updating the hours?
Should I have a separate access table with matching keys (Project numbers) and just query them together?