Alternative to Importing Large File
I have a large file that I need to import into my Filemaker Pro 12 database daily; sometimes twice a day. I import from an Excel sheet which has around 35,000 records (and maybe around 10 fields in each record). The import takes forever, and I'm hoping to find a workaround that saves me time.
I need to import this file as there are certain fields in here that change daily and regulary. This information is pulled from another database that I am working alongside.
I've tried a script that deletes all records, and imports everything as a new record. I'm currently updating matching records. I don't know which is quicker but they both take forever.
In Access, you can link to an external Excel spreadsheet as a data source - this would be the ideal solution here, I think. Can this be done?
If not, does anyone have any suggestions to speed up this process for me?