Posted on: 11/26/2012 2:55:44 PM | Views : 719

With sql server 2008 r2 express I tried to import data from an Excel spreadsheet into a database and I got this error message:
Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component
'Ad Hoc Distributed Queries' because this component is turned off as part of
the security configuration for this server. A system administrator can enable the use of
Go to the complete details ...