dought

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

Discussion created by dought on Nov 7, 2015
Latest reply on Nov 11, 2015 by user19752

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.

Outcomes