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