I've had this post in the importing and exporting forum. 39 people have looked at it and I've gotten no replies. Perhaps the people viewing in that forum didn't have an answer, perhaps it's a "dumb" question like "how do I make a database", or perhaps there's no answer. I thought I'd give it one more try here....

I want to update a database by importing data from a tab delimited file on a daily bases. The database is hosted by FMP server 5 on a Win 2000 server. Is there a way to automate the process. I've looked through the scripts, but how do you automatically trigger the scripts?

FMP does not have any method of triggering a script built-in. There are 3rd party tools out there that will do what you want. You could possibly put this script as a start up script. It would then import the records every time you open it. If you opened it up more than once a day, it would rerun the import script but if you delete the file after the first run, it wouldn't import anything. Just a thought.

HTH

John