Search results

Hi. I am exporting data from Excel into Access temp tables and then trying to write update/append queries to transfer the data to permanent tables. I have this scenario: STAFF table StaffID [Autonumber] [PK] StaffCode PRODUCTIVITY table ProductivityID [Autonumber] [PK] Date StaffID [FK to...

Hi. Firstly, I hope this is the right forum. I wasn't sure if this was a Query issue or something more general. I'm trying to update tables in my DB using temporary tables which have been imported from Excel. I have set up Unmatched and Duplicate queries and then Append and Update queries for...

Hi. I know this is a fairly common problem, and have trawled both these forums and Google to try and resolve it, but I still can't so I hoped that posting specifics of my DB might help. I am importing data from Excel to a temporary table (with no PK) as follows: tblTEMP Date Login (actual login...

I'm trying to create a Staff Database to track hours spent in various activities each day. Each member of staff is in one team at a time, but moves between teams. I've simplified my table set-up for demonstration Staff StaffID - PK for Staff table StaffName Team TeamID - PK for Team table...