Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Automatically Inporting Data from MS Access


bwill2000

This topic is 7840 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7840 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.