What my goal is to send data from my Excel file to my Access file. Then from my Access file, I wish to query it to my Sharepoint List. How I am trying to do so is
1. Use a Excel worksheet to Access Transfer, that only has data appear, if it isn't already on the Sharepoint List. This is done by comparing a query of Sharepoint to Excel worksheet ?Entry Log?.
2. Excel worksheet to Access Transfer is linked inside of Access.
3. Sharepoint List is linked inside of Access.
4. Query to Append the linked tables inside of Access to update Sharepoint List.
5. This in turns updates the Excel worksheet to blank.
The problem is when I link the Excel file to Access, it creates several blank records in Step 2. So, when I run the query to combine the two linked tables in Step 4. I end up with 20,000+ records, when it should be 20 records.
I am very unfamiliar with Access, so I am not sure where to start to not pull empty records into the linked Access.
In the attached, I have two access databases and one excel file.
The Excel I the file linked to the Access Transfer.
The Destination access is to simulate the Sharepoint List and is linked to the Access Transfer.
And the Access Transfer is the file linking everything together.
If I need to clarify anything else, just let me know. Thank you for your time and help.
Bookmarks