Comments on SQL Yoga: SQL SERVER: How to Read Excel file by TSQL

Hi Steve, We can read file from any location wher...

2012-02-18T11:35:41.610+05:30

Hi Steve,

We can read file from any location where SQL SERVER instance is running. e.g. If system has D drive then it can read like D:\SQLYoga.xls.

About to read from Network location, SQL can read file from network location to. For that, please make sure that SQL SERVER account has an access to that network location. If SQL server has an access to that location, we can

Can you only read a file that is stored on the c: ...

2012-02-18T02:18:12.822+05:30

Can you only read a file that is stored on the c: drive of the local SQL Seerver? Is it possible to access an excel file that is located elsewhere on a network? How?

Hi, It means you need to allow this from server. ...

2009-12-24T15:54:15.799+05:30

Hi,

It means you need to allow this from server.

You need to enable "Ad Hoc Distributed Queries" configuration to run this query.

You can enable this deature by:

sp_config 'Ad Hoc Distributed Queries',1
reconfigure

Thanks,

Tejas

while running query i gave error Msg 15281, Level ...

2009-12-24T13:09:20.148+05:30

while running query i gave error
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 'Ad Hoc Distributed Queries' by using