How do I keep filemaker pro updated with data that is going into excel spreadsheet?

Posted on 2011-05-09
Last Modified: 2012-05-11
I use excel spread sheet for our data, and then generate reports in filemaker pro 11.  How can I maintain an update date base in filemaker when I am putting data into excel?  Can I have filemaker update each time that I update (add/subtract data) in the excel spread sheet.?
Question by:topgun0621
    LVL 12

    Expert Comment

    First, I don't understand how you are using Excel and why generate the data there.  Why not just use FM to generate the data too?

    One idea to explore is using ODBC.  You could create an connection to the spreadsheet and then use FM to use it like an external database.  But you would have to have the same sheet each time.  

    Author Comment

    we type up a forecast of what is to produced on the various machines daily in a excel spreadsheet.  This tells us the order that products are going to be produced.  It is basically an information sheet for workers, supervisors,QC, outside fork lift drivers.  
    The information we type in the forcast is then sent to another tab in the work book called description.  This compiles any new descriptions of products that we make so that it is readily available.  
    Then the information typed into the forecast tab of the workbook also goes to the certifieds tab in the workbook.  This is where we need the information for the certifieds report in filemaker.  I imported this file into filemaker, but this file gets added to daily.  So as the excel file gets new data I need the filemaker file that was imported to be updated at the same time.

    Do you follow me, or would an example of the file help?
    LVL 12

    Accepted Solution

    I think I follow.  My question would be can the data be generated in FM rather than Excel?  If you were to use FM you may be able to cut out the Excel process.

    Now, one thing you might look at is a pure import, but it would be a manual process.

    Author Comment

    Hmm, using FM instead of excel may work.  Although I am not sure I can duplicate the forecast like we have it but I believe your right that may be easier.  This is the file I have that we generate the forecast, certified form (which we would eliminate becasue the data would be going directly in to FM) and the weld shear form.  The weld shear form we need so that when we pull the tests we write the results in the boxes and then file.

    This is a typical example.  I type the orders in the forecast tab and copy and paste into the other 2 tabs in the work book.  I then only have to change a few things like welder, wire sizes, date and when we have to pull samples to stay with industry spec.  Do  you think this can be done in FM? Daily-Paperwork.xls

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now