I need to import excel files in to a Filemaker 10 database.
How do I go about importing the excel file so the data relates to the proper tables?
the database has numerous tables for managing an art collection.
A table for the artwork, another for artist info, another for history, another for images and so on...
I am okay doing multiple imports linking the fields in the excel file imported to the appropriate tables, but what is the best way to do this without extensive scripting and to ensure that the data from the excel file will relate properly to the existing data?
Would it be best to create a temporary database and then merge the two together?