2016-01-12

TSQL - How to solve "Could not find installable ISAM" error


sp_configure 'show advanced options', 1;
RECONFIGURE;
go
--> Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.


sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO
--> Configuration option 'Ad Hoc Distributed Queries' changed from 0 to 1. Run the RECONFIGURE statement to install.



If that is not enough, then also install "Microsoft Access Runtime 2010" (or the version that fits your system and the type of file you're trying to upload). This runtime works for integrating at least Excel 2010, Excel 2013 and Excel 2016 files.

No comments:

Post a Comment