Welcome to the MacNN Forums.

NordicMan · Jan 28, 2006, 05:29 AM

For those who use these two, how well do you find they work together? It is a business setting that they would be used in.

SWFan · Jan 30, 2006, 10:40 PM

Filemaker Imports/Exports Excel files without a hitch. From Excel's perspective it opens xls files prepared by FMP just fine. Not sure what other kind of integration you might be referring to though.

I typically use FMP to generate a report of results and use its export function to create an email with an xls attachment of the results.

the3rdParty · Feb 1, 2006, 04:12 AM

do some careful research if you want to use ODBC connectivity from FM to Excel. When you get this set up its really great but although this worked ok on OS 9 with FM5 (if I remember correctly), but as far as I am aware there are no ODBC drivers for this under OSx. It would be great if I was wrong. You may find some info here:

http://groups.google.com/group/micro...c.office.excel

the3rdParty · 07:32 AM

Correction to my previous post, it looks like ActualTechnologies now have ODBC drivers for OSx. I believe that they offer a solution that would work between Excel & Filemaker, although it appears that the focus of their products is to enable these two programmes to connect to other databases (incl MS Access) rather than to each other. May be worth contacting.

http://www.actualtechnologies.com/products.php

If they have a solution that suits you, try it out first. With OS9 the functionality was fantastic but the link was a bit slow if the filemaker db was big and the query complex.