Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    64

    Angry Unanswered: Export to Access

    We have an existing file maker pro database, I would like to export all the data from it and import it into MS Access, is that possible?

    Thanks

  2. #2
    Join Date
    Aug 2005
    Location
    Minneapolis, MN
    Posts
    56
    Should be. See what the compatible formats are that your Access database can import, and export your FileMaker data into a text file using one of those formats. Then import that into your Access database.

  3. #3
    Join Date
    Mar 2004
    Posts
    64

    export

    Thank you, it's helpful

  4. #4
    Join Date
    Jun 2005
    Location
    Perth, Western Australia
    Posts
    7
    Be careful, I think Access may still have limits on the amount of characters
    you can import into a field. I had major problems moving material from
    FMP to Access a few years ago and ended up having to find all those fields
    where the number of characters in a field exceded 256 and split them
    into even lumps and knit them back together later on. It was a major
    pain to do so and I cannot for the life of me work out why most other
    databases have such difficulties importing fields with large numbers of
    characters.

    R

  5. #5
    Join Date
    Dec 2009
    Location
    Bangladesh
    Posts
    8
    U can use FmPro Migrator.

  6. #6
    Join Date
    Apr 2008
    Location
    Dallas, Texas
    Posts
    22
    Yes, there are limits to Access because FileMaker is a much more robust database. Actually, Access is only a front end "access" to real databases and Microsoft's real database backend is MS SQL Server. But you can use Access for lighter duty single user files just fine. I frequently serve up FileMaker via ODBC and you can actually have Access be a front end to data on FileMaker through an ODBC connection, which is always interesting. It is more commonly done with MS SQL Server, but it does work with FileMaker. That way you would have what you want for a User Interface with Access and the bigger power of FileMaker as a server. Of course I think FileMaker has a much better User Interface, but more people seem to know Access. Also, FileMaker is easier to secure. But for exports, you can export to a number of formats. If the tables aren't too big, then an Excel format works fine. Otherwise use DBF, just realizing that field names will be truncated at 8 characters. Tab Delimited is also a favorite that you can export and then import from.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •