Hi
I'm hoping someone with more knowledge than me about this can help me out.
Right now, I have a set-up where I have a big MS Access database with numerous queries. The whole database is based one one table (called Transactions), which I import from Excel that I receive daily. Right now, I have to manually import the Excel file through External Data -> Text file -> Today's Excel file.
In an ideal world, I would be able to run this automatically. My question is therefore, if there is a way to automatically import the Excel file i'm receiving everyday to my Access database without having to click anything. I'm getting the Excel file from another program, which I have set up to receive daily in a specific folder. Is there a way for Access to import the Excel data into the Transactions-table so all the queries based on the Transaction-table can run everyday automatically?
I have tried reading this forum and watching videos, and I think I may have to use some VBA. However I've not succeeded yet.
Many thanks in advance,
T
Bookmarks