I have a question about importing an excel document into FileMaker with the following goals…
There will be multiple excel files that will import client data into a main FileMaker database. Each of these excel files has a "client type” column that is the same for each excel file, yet each excel file has a different client type.
So, for instance, excel document number one has a client type column that lists all clients as “Green” and the second excel document has the client type column listed as “Blue”.
What I’d like to do is import each excel file into the FM database that places the client type into a “client type field” that has different options.
What’s a good way to go about this? How might you setup the FM database to import this data? And how would you setup the FM database for this type of import? There will be a constant importing of this type of data weekly, so it’s not just a one time process.
Thanks for any feedback.