I have this excel spreadsheet that is quite large.
I would like to be able to link to this excel spreadsheet.
The problem is that there is a lot of garbage above the actual column names which makes linking and appending data to this excel file difficult.
How can I link to an excel spreadsheet that would allow me to Append data to it taking into account there is a lot of extra stuff between row 1 and the row that contains the actual headers? I thought a possible solution might be assigning a named range to the row that contains the column names but I am not sure if this strategy will allow to APPEND data to the last row of data.
Also, under a linked excel file setup, does Access APPEND to the last row of data or do you have to have extra code for this?
I have never done something like this and am looking for some tips.
I can not edit the excel file...meaning the extra garbage will have to stay there.
(attached picture of excel file wanting to link to. Notice rows 1-5)