[AccessD] Files maker pro and Access

There is this $100 product
It is supposed to go in both directions with Access There is a trial 
version, also produces scripts
FmPro Migrator generates the scripts required to document and migrate 
FileMaker Pro database structure and data to MySQL, Oracle, Access, SQL 
Server, Sybase, DB2, PostgreSQL and FrontBase.

http://www.fmpromigrator.com/products/fmpro_migrator/fmpro_migrator_features_benefits.html

Annie Courchesne, CMA wrote:

>Chris,
>
>Thanks for the info, I will try this with the demo version of file marker
>pro.
>
>
>Annie
>
>
>-----Message d'origine-----
>De : accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] De la part de Chris Mackin
>Envoyé : 30 avril 2005 13:25
>À : Access Developers discussion and problem solving
>Objet : RE: [AccessD] Files maker pro and Access
>
>You can link to FileMaker Pro via ODBC that comes with FileMaker Pro.  It is
>very frustrating and FMP is a piece of s*** application, but I've done it.
>One key pitfall, and there are many, is that FMP must have the file open
>that you are connecting to, otherwise the ODBC connection will fail.
>
>-Chris Mackin
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Annie
>Courchesne, CMA
>Sent: Friday, April 29, 2005 8:25 PM
>To: 'Access Developers discussion and problem solving'
>Subject: RE: [AccessD] Files maker pro and Access
>
>
>Thanks for the info.  I will download the demo and do some further testing.
>
>Annie
>
>-----Message d'origine-----
>De : accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] De la part de Stuart McLachlan
>Envoyé : 27 avril 2005 21:55
>À : Access Developers discussion and problem solving
>Objet : RE: [AccessD] Files maker pro and Access
>
>On 27 Apr 2005 at 20:18, Liz Doering wrote:
>
>  
>
>>Annie,
>>
>>I have found that FileMaker Pro can export to .xls or .dbf, but it isn't
>>itself a format that Access can link to.  So your import will have to be
>>a two step process, one an export from within FileMaker Pro, then a
>>separate import into Access.  Your best hope will be to get some
>>familiarity with FileMaker Pro:  they have a 30-day free trial at
>>https://www.filemaker.com/downloads/trial_download.html
>>
>>    
>>
>
>
>Filemaker Pro claims to allow you to access it's data from other
>applications using ODBC, but there is very little detail on their website.
>I suspect the ODBC driver comes as part of their Development Package.
>
>You could also try the Fielmaker Pro ODBC driver at
>http://www.versiontracker.com/dyn/moreinfo/macos/1602
>
>
>--
>Stuart
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada