We have a database field that contains the URL to an Excel file in a folder on a remote server and want to import that Excel file into the FileMaker DB with field matching. What is the best approach?
Something that I did was since I knew the name of the remote file I could do an insert from URL into a global container filed that was set for external storage. This pulled the file on to the local server. Since I knew the name of the file and where it now resided I could do an import. The import dialog won't let you specify a non-FileMaker, remote file. This gets around that.
Retrieving data ...