Skip links

FileMaker Quick Tip: Importing entire data tables

FileMaker training, courses, coaching

FileMaker Quick Tip: Importing tables into a FileMaker databaseAnyone who develops FileMaker databases will sooner or later want to import data tables from one solution to another, and not just once. It can also happen that data tables from other database systems such as mySQL or others are imported via ODBC addressable databases are to be transferred. With the current FileMaker versions, a Table of another system, including field definitions and all the information they contain, can be easily imported in one go using the import function.

For this purpose, first open the FileMakerDatabaseinto which a table from a third-party system is to be imported. Now select

File > Import data records > File.

Now select the table to be imported in the left-hand column under "Source" in the dialog for the field assignment. In the right-hand column, select the entry "New table" under "Target". After the import has been started, FileMaker automatically creates a new table in the target file with all the fields that are in the source table. This procedure also works smoothly with external tables. SQL-databases via ODBC. You can then rename the newly imported table in the database definition and use the table immediately in your FileMaker database.

FileMaker Training and Coaching
Display

Leave a comment

  1. Cool, I didn't even know that this was possible! Until now I always missed the copy & paste function in the table definition in my FileMaker Pro and was already thinking about buying an Advanced. But this way it's even faster and without an Advanced version :-)

  2. I am looking for a way to import a txt file with data from a web address directly into Filemaker Go under IOS.

    Is there a way?

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: FileMaker Quick Tip: Importing data tables from third-party systems into FileMaker