Provider for External Database

I want to manage the object creation by using the excel file. I created a User/System DSN through Windows ODBC Data Source (32-bit). However, I can't find this option in M-Files admin when I choose to use Microsoft OLE DB Provider for ODBC Drivers. Please advise me whether excel can be used for external database connection.

Thanks,
Henry

Top Replies

Craig Hawker 1 month ago +2 verified

We do not recommend using Excel or Access as data sources. This is noted in the user guide: Using the Legacy Database Connection for Value Lists (m-files.com) See also this support article indicating…

Parents

+1 Craig Hawker 1 month ago

We do not recommend using Excel or Access as data sources. This is noted in the user guide: Using the Legacy Database Connection for Value Lists (m-files.com)

See also this support article indicating one of the issues that can occur using this approach: Optimize Database Thorough Fails Because Access Data Driver in Use with External Objects (site.com)

Instead consider loading the data from Excel into SQL Server or similar and importing the data from there.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

+1 Craig Hawker 1 month ago

We do not recommend using Excel or Access as data sources. This is noted in the user guide: Using the Legacy Database Connection for Value Lists (m-files.com)

See also this support article indicating one of the issues that can occur using this approach: Optimize Database Thorough Fails Because Access Data Driver in Use with External Objects (site.com)

Instead consider loading the data from Excel into SQL Server or similar and importing the data from there.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

No Data

Provider for External Database

Top Replies

Contact Us

Schedule a Demo

Careers

Trust Center

Privacy Policy

Security Hall of Fame

M-Files Community

Support Portal

Help Center

Product Center

Download M-Files

User Guides

Product News