How to import a folder of multiple excel files into a database?
I have hundreds of excel files with data and my FileMaker database with corresponding fields that I have been importing one by one using Import record ---> import file, selecting the individual excel file and match the names up with fields on the database records and import the excel file data one by one. This is time consuming so I am looking for a way to import a folder of excel files at once and do the same thing automated and much faster. As far as I know, FileMaker pro can only import folders of .txt and image files. Does anyone know how to import folders of muliple excel files? I think you can write a script within FileMaker to loop through files and import them, but I am having trouble with this because I cannot seem to set my variables and paths right. I couldn't figure it out using free Mac plug-ins either (unless anyone can assist with that). Any help is appreciated, thank you!