[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2011-05-09
Medium Priority
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
  • 2
  • 2
LVL 12

Expert Comment

ID: 35720227
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

ID: 35720967
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

North2Alaska earned 2000 total points
ID: 35721237
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

ID: 35721428
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Loops Section Overview
Suggested Courses

873 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