I just wanted to report back saying that I have it working now and wanted to thank all of you for your input.
It imports the file, creates a log that it was successful then moves the file to another location for me to verify that it was imported if needed. All of this is started via the task scheduler.
Edit:
I also wanted to add that this was a fresh DB that only has the main table, a temp table and a few queries plus a macro. There is no user interface whatsoever as this is purely for data storage for Power BI to attach to and visualize.
It imports the file, creates a log that it was successful then moves the file to another location for me to verify that it was imported if needed. All of this is started via the task scheduler.
Edit:
I also wanted to add that this was a fresh DB that only has the main table, a temp table and a few queries plus a macro. There is no user interface whatsoever as this is purely for data storage for Power BI to attach to and visualize.
Last edited:
