Check Querying an ODBC data source from FileMaker Pro.įileMaker can import table data from Access (or other databases). Make an ODBC connection to your Access database, and use it from within FileMaker to import your tables. When you install Office, you normally get ODBC controllers installed by default, so, if you have Access installed in your computer, you're very likely to have ODBC controllers as well. 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):
0 kommentar(er)
