Hello, I am trying to find a way to make a button or some system that in the end will:
- open a pre defined table and append the data to and archive table then clear all data
- open an pre defined Excel file and import to the data into the cleared table
I have been trying to research this, but I do not know sql so I don't know if the examples I am reading will work for what im looking for. I didn't know if I could use Access's macro builder to create what I need, or how I would need to go about it. I could not find any examples that said they were doing what I am looking for so I was hoping I could get some guidance.
Im not sure what info would be needed, but let me know.
Thanks,
Will