4 Replies Latest reply on Nov 11, 2015 8:05 PM by user19752

    Problem connecting from FMPA 13 to Excel 64 bit data source via ODBC

    dought

      I am using FMPro Advanced 13 on a Windows 10 64 bit system and trying to import to FileMaker from MS Excel 64 bit via ODBC.

      I have checked in Administrative Tools and ODBC Data Sources (64-bit) includes the default "Excel Files" User Data Source Name which has no Workbook specified.  For testing I added another DSN which does have a Workbook specified.

       

      For both of these DSN, when I try in FileMaker: File, Import Records, ODBC data source, select a DSN I am prompted to enter a User name and Password.  The Excel file I wish to import has no password.

      If I leave these details blank I am told that "The account and password you entered cannot be used to access this file."

       

      I would appreciate any advice about how to get past this problem.  Thanks in advance.