FM to Access via ODBC?

[CompuBooks]

Hello Forum -

I am wanting to 'push' or transfer data to Access from FileMaker as seamlessly as possible, and was hoping to utilize ODBC drivers. I want the user to be able to push a button in FM, and have the data magically appear in Access. Does anyone know how to do this so that the user has no interaction with Access? Would this require some outside plug-in or app?

[DanBrill]

Hi CompuBooks,

Accounting and FM is a pretty big issue for me, but not an issue that gets loas of discussion in this forum, so I was glad to see you sign on.

As for your question, I'd script a data export [no dialog option on] to send your FileMaker data to a text file. Your script can then go on to launch an Access Macro that will import the text file that was generated by FM. (Take a look at the SendMessage command in FM to see how to start another program.) I know you can start Access and have it execute a specific macro. I'm not entirely sure how you do it if Access is already running. But given that Access is so reliant on VB scripts, I'm sure it can be done.

In any case, I'm sure you could do this without a plugin.

Take it easy,

Dan