AnsweredAssumed Answered

Alternative to Importing Large File

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

Title

Alternative to Importing Large File

Post

     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?

     Thanks!

     Ian

Outcomes