T
Ted M H
Hi,
I know this is not the Mactopia forum but for some reason that forum won't
accept my post, so in desperation I'm posting here.
I’m trying to set up and Excel 2004 pivottable that uses a FileMaker Pro
file as its data source. I do this all the time in windows (Excel 2003 or
2007 with Access), and it’s very simple.
I bought FMP v10 and I’ve created my database, but when I try to create my
Excel 2004 PivotTable here’s what happens:
I click the External data source option on the PivotTable Wizard step one
and click Next.
Then I click the Get Data button on PT Wizard step 2.
This opens an empty window titled iODBC Data Source Chooser with two pages:
User DSN and System DSN. If I click Add on either page I get another empty
window. This one is titled Choose an ODBC driver.
Problem is, there’s nothing to choose from.
I understand that FileMaker comes with its own drivers. How can I find the
right driver and get it installed so I can do my PivotTables?
Thanks very much.
I know this is not the Mactopia forum but for some reason that forum won't
accept my post, so in desperation I'm posting here.
I’m trying to set up and Excel 2004 pivottable that uses a FileMaker Pro
file as its data source. I do this all the time in windows (Excel 2003 or
2007 with Access), and it’s very simple.
I bought FMP v10 and I’ve created my database, but when I try to create my
Excel 2004 PivotTable here’s what happens:
I click the External data source option on the PivotTable Wizard step one
and click Next.
Then I click the Get Data button on PT Wizard step 2.
This opens an empty window titled iODBC Data Source Chooser with two pages:
User DSN and System DSN. If I click Add on either page I get another empty
window. This one is titled Choose an ODBC driver.
Problem is, there’s nothing to choose from.
I understand that FileMaker comes with its own drivers. How can I find the
right driver and get it installed so I can do my PivotTables?
Thanks very much.