Convert from FileMaker to Access

[Catherine Feldhausen [MSFT]]

Hi,

I am trying to help a non-profit org convert their database from a FileMaker
(on a Mac) to Access on a PC.

Can anyone help? I am stumped have checked out help, knowledge base articles
etc, but don't seem to be able to find anything.

--
Cheers
Catherine
PM Community Team

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[John Vinson]

Hi,

I am trying to help a non-profit org convert their database from a FileMaker
(on a Mac) to Access on a PC.

Can anyone help? I am stumped have checked out help, knowledge base articles
etc, but don't seem to be able to find anything.

It ain't easy.

The user interface - forms, printouts, etc. - will have to be rebuilt
from scratch. They are utterly and completely different, and there is
no way to convert them.

The data can be transferred, with some difficulty. What I've had to do
is to Export the data from FMP to dBase format, and import it into
Access.

FMP is rather less "relational" than Access, and includes non-standard
things such as storing calculations in Tables. These will all have to
be removed and rebuilt in Access queries.

Contact me offline if you'ld like some more details.