School project, Help needed with FileMaker PRO

Discussion in 'Mac Apps and Mac App Store' started by Flashtastic, Jul 8, 2007.

  1. Flashtastic macrumors newbie

    Joined:
    Jan 22, 2007
    Location:
    Australia
    #1
    Hi all.

    I am working on an assignment for school and am having trouble with how to do one part:

    It says I need to link a spreadsheet to a database so that when I change the spreadsheet, the database also changes.

    I have found FileMaker PRO 5.5 Trial which is one of the few versions which actually works with Excel 2004's import feature.

    I need to know if this is possible:
    In the same way that I can import a FileMaker PRO file into and Excel spreadsheet and have it "update" the contents of the cells whenever my FileMaker document changes, can I do the opposite?

    So when the Excel file changes, so does the information in the FileMaker document?


    If this isn't possible, is there any kind of database that will work with Excel, other than Access?

    Thanks :)
     
  2. Flashtastic thread starter macrumors newbie

    Joined:
    Jan 22, 2007
    Location:
    Australia
    #2
    Is there any update for Excel for this to work?
     
  3. CanadaRAM macrumors G5

    CanadaRAM

    Joined:
    Oct 11, 2004
    Location:
    On the Left Coast - Victoria BC Canada
    #3
    Go to Filemaker's website and/or Help and search for ODBC and MS Query
     
  4. Flashtastic thread starter macrumors newbie

    Joined:
    Jan 22, 2007
    Location:
    Australia
    #4
    Thanks heaps!
    I have another question though…
    When viewing my database in table view, one of my fields is missing!
    In the "Define Fields" Dialogue, there are nine fields, but in my table there is only eight.
    Is there any way to get it back?
     
  5. Flashtastic thread starter macrumors newbie

    Joined:
    Jan 22, 2007
    Location:
    Australia

Share This Page