Filemaker Pro Conversion

[Guest]

A client has been given an FP7 file and no copy of FileMaker Pro. Since
Access 2007 won't open such a file directly, does anyone know of a converter
that would make this possible?

Thanks in advance.

 

[Tom van Stiphout]

On Thu, 24 Jan 2008 23:13:31 -0500, "nospam" <[email protected]>
wrote:

What happened when client asked the Source for the data in a format he
could actually use?
-Tom.

 

[Guest]

"The owner won't send it in any other format," sez he. He's contacting
Filemaker directly, but I suspect they'll just try to sell him a copy of the
program.

So, do you have a suggestion for conversion or import?

 

[Tom van Stiphout]

I don't think there are any, except for Filemaker itself. For example
I've never heard about a Filemaker ODBC driver. It's probably just too
small a product.

-Tom.

 

[Guest]

So far, I've found two possibilities: i) an ODBC driver downloadable from
the FM site itself as a supplement to the FM 30-day demo (but ODBC access
may require a setting within the file to be enabled first via FMPro); and
ii) FmPro Migrator (www.fmpromigrator.com), which looks like it may require
that FMPro (perhaps the demo) be installed in order for it to work.


It might also be possible to install the FMPro demo version and see whether
it can output a DBF or some other format that Outlook will open, but I
understand that the customer's DB contains image files that must not be
lost.

More suggestions will be welcomed.

 

[Albert D. Kallal]

I would try a and download the trial version of filemaker. You then open the
file, and then export the data into something like excel, or something like
comma delimited (csv) format that access can read.

You might even be able to have better luck with using some of the dBase
formats that filemaker can export to also.

After you export, you won't have to worry about some ODBC driver set up here
either....

I wouldn't bother to setup odbc and try to import directly from filemaker,
simply use the demo edition of filemaker to export the data into something
that MS access can read....

 

[Larry Linson]

And I'd caution that you need to be sure that the ODBC driver is to allow
some other application to access FileMaker files -- it may well be that it
is only to allow FileMaker to access files from ODBC-compliant applications.
(For example, you can, from Access, access ODBC-compliant databases using
ODBC, _unless_ the ODBC in question is an Access database... you can access
an external Access database but directly, not via ODBC.)

Larry Linson
Microsoft Access MVP