

Check: Introduction to importing and exporting data (Access) and Bringing data into FileMaker Pro - Overview and troubleshooting.ĭirect import through ODBC: Directly import the tables from FileMaker by means of an ODBC connection**.

You can also try Excel as an intermediate export format (with this format, you may have some limitation if you have long texts). The safest format is normally CSV -comma separated values- although it won't work with FileMaker if you have data with line-feeds or carriage-returns inside. Use intermediate "common import/export formats": Export data from all the different tables in Access in a format that FileMaker Pro can immediately import, then import the exported files from FileMaker. You have basically two options (without resorting to any third party tool, besides ODBC):
