I would like to automate the updating of my database. I recieve volume reports monthly and only require the previous months reports on a regular basis. I would like to be able to either link the monthly or import the monthly reports (they are Excel worksheets) into the Database while deleting the old information. Does anyone have any suggestions.
I have explored the saved import method however it does not work for me becasue I am not updating the old excel workshet, I am replacing it with a new one. I use the old work sheet as a sort of archive in the event that I ever need them.
Is there any way I could have a static worksheet automatically update with new information each month and then simply link to that static worksheet?