Is there a way to automate and import to access from files that sit in a file share?
I would like to use FTP to get a file daily, then run a scheduled task that would open access and then import those files and run a macro or vba. I am thinking i could set up and automacro to run when the database opens but I dont want someone to accidentally open it and try to run the import.
Is there a good way to import straight into access from a file share?