Table Creation On FileMaker Data Import Explored

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Most traditional FileMaker import routines involve importing data into field in an existing table. There is another option that can be used to automatically create a new table (with needed fields) on the fly. This can be a little difficult to see at first glance because this option is found near the very bottom of the target table list.

Click the image to get a better view

I’ve used this option a number of times when doing client work, usually involving value lists. A customer may say they want a value list to match some certain criteria and they sent that to me in an excel spreadsheet. It is quite easy to import this data as a new table and then use the option to use existing values for a value list. You simply point the source of those existing values to your newly imported data table!

FileMaker does a pretty good job overall of trying to match the field types and names you probably want in your newly created table. However, you may find a need to tweak both of these for your particular needs. Give it a try sometime and see how it works out for you!

© 2010 - Dwayne Wright -
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.