I am starting from scratch with very little knowledge of Access.
I have an Excel Spreadsheet that is emailed to me weekly
I need to append to the database weekly (cols A&B only)
I also need to add to the database an additional field on import
either the data in cell B7 (week number) or the import date so the week number can be calculated in a query later.
My problem started when I imported the initial file and then tried to use append a copy feature. Access complained about the field names not matching.
So I am stuck at 1st base.
My data will always come into Access via spreadsheets and not user
What can I do?
Martin