I'm not sure how the best way to do this, but I want to import an excel file using a batch file or something similar. Right now i'm using a plug-in with thunderbird to automatically save the file to a certain folder when it hits the inbox. This plug-in will also let me execute a command or program.
Can someone point me in the right direction. I wondered if you could execute access with switches to run saved imports, or if a batch will would be better.
Currently there are only two different files that come by two different emails, but this will eventually grow to about 6 files.
One way among many: You could make an Access database that has a form which, when opened, does the import with VBA. You then set that form as your startup form. Then you only need to open the database and an import will happen.
No, you can't do that without opening Access. But it depends on what you mean by that.
For example you could have a scheduled task set up that opens the database (in Access) automatically. It still needs Access to do it, but no-one has to do it. That database needs to do what it needs to do and then it needs to close itself.