Hi everyone,
I was wondering if there was a way to take two columns on a linked excel sheet in Access, and merge them with an in-house or SQL linked table in Access that has those two columns as well? The purpose is so that I can take the two columns in the linked excel sheet, and have them updating to the in-house access table where I can add data associated with them, then export it. To give some context, the linked excel sheet in my access DB is an automated data dump that occurs daily.
Thanks