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.