FileMaker to SPSS via ODBC

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

FileMaker to SPSS via ODBC

Roger A WIRT
We're wondering about the feasibility of using SPSS [PASW] 18 to extract
data via ODBC from FileMaker ('Pro 11 Advanced') but have hit a snag.  With
a confirmed ODBC DSN and FileMaker internal privileges & permissions set,
we obtained these results on a Windows XP system:

 Simple test database (3 rows, 2 columns):
  Worked with Excel 2007(which successfully read the FM data via ODBC);
  SPSS merely displayed column headings and wouldn't fetch data.

 More complex test database didn't work at all:
  Excel 2007 displayed an hourglass (which we terminated after 1/2 hour).
  SPSS recognized table-occurrences, displayed column headings, no data.

Any comments would be much appreciated.

version numbers:
 FM 11.0.2.0, FM ODBC driver 11.0.61
 SPSS ('PASW') 18.0.0
 XP Pro SP3

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD