FM - Is There a Way to Point to Which Excel tab you want to Import?

Posted on 2014-07-15
Last Modified: 2014-07-16
Is There a Way to Point to Which Excel tab you want to Import?  I don't see anywhere in the Filemaker import script step where you can select the tab.  I have way too many tabs I need to import and I'd rather not Save As a hundred times in order to have the correct tab be imported.  If not, what is the workaround?  Thank you.
Question by:rvfowler2
    LVL 2

    Author Comment

    I found that when I select a different file, it allows you to choose which tab, but the only way to choose a different tab is to select the file all over again.  Anything easier?
    LVL 24

    Accepted Solution

    I don't know of a way to do it that is completely automatic. You can make the import dialog visible and then select each tab in succession but of course that leaves you open to errors….

    360Works Scribe Plugin can read from and write to Excel, Word and PDFs, so it might be able help with an import from a selected Worksheet within an Excel Workbook, but I've not tried it to know.
    LVL 2

    Author Closing Comment

    Thanks, will look into 360Works scribe.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    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…
    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…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    760 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

    9 Experts available now in Live!

    Get 1:1 Help Now