AnsweredAssumed Answered

Alternative to Importing Large File

Question asked by IanLenehan on Mar 25, 2013
Latest reply on Mar 26, 2013 by IanLenehan


Alternative to Importing Large File


     Hi Everyone

     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?