Automatically Inporting Data from MS Access

[bwill2000]

Dear All,

I have a MS Access database which is used by Sage Accounting software. I would like to import data from this database to my Filemaker database. I have set-up an ODBC driver and I can import records through the import ODBC source option. This works fine, but is there a way I can automatically do this? Make filemaker import the records every 5 mins or so.

Any ideas, or am I asking to much?

Thanks

[cjaeger]

you can define your odbc-connection in unstored calcs, then data is accessed every time you refer to it (dynamic table, good wher you are only referencing some data from this table, but do not need all the records locally).

or you can trigger the import by a looping script running all the time (not a good idea for shared databases)

manual import is just fine with me, because then i am around when errors pop up because someone closed the access database.