I have several tables that all have the same column headers. I understand normalization and the need to have one "main" table that differentiates between what the data pertains to with an additional column.
Each week I need to update my table with an additional few hundred rows.
I'm sure this is not the best way to do this but as of now I converted all of the data to one large Excel file and update it in there using an Excel macro. Once all of the rows are there I load it into Access via a linked table. I imagine there being an easier way to do this. My excel file is growing too big and slow and it doesn't serve the purpose I am looking for from Access.
My questions:
- what is the easiest way to update from an excel file to an existing access table? append query, linked table, etc.
- I don't fully understand the capabilities of Access Macros but could one be used in this situation?
Any response would be GREATLY appreciated.
Thank you!
Each week I need to update my table with an additional few hundred rows.
I'm sure this is not the best way to do this but as of now I converted all of the data to one large Excel file and update it in there using an Excel macro. Once all of the rows are there I load it into Access via a linked table. I imagine there being an easier way to do this. My excel file is growing too big and slow and it doesn't serve the purpose I am looking for from Access.
My questions:
- what is the easiest way to update from an excel file to an existing access table? append query, linked table, etc.
- I don't fully understand the capabilities of Access Macros but could one be used in this situation?
Any response would be GREATLY appreciated.
Thank you!