<div>
please clarify what you try to do.<br />
<br />
<br />
if you plan to query Excel from sql server<br />
you can set linked server:<br />
<br />
How to use Excel with SQL Server linked servers and distributed queries<br />
<a href="http://support.microsoft.com/kb/306397" rel="ugc">http://support.microsoft.com/kb/306397</a><br />
<br />
<br />
or use OPENROWSET<br />
<a href="http://technet.microsoft.com/en-us/library/ms190312.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms190312.aspx</a><br />
&nbsp;for example:<br />
SELECT * <br />
FROM OPENROWSET('Microsoft.ACE.<wbr />OLEDB.12.0<wbr />',<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Excel 12.0;Database=c:\test.xls;<wbr />HDR=YES',<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'SELECT * FROM [Sheet1!$C$2])
</div>


please clarify what you try to do.


if you plan to query Excel from sql server
you can set linked server:

How to use Excel with SQL Server linked servers and distributed queries
http://support.microsoft.com/kb/306397 [http://support.microsoft.com/kb/306397]


or use OPENROWSET
http://technet.microsoft.com/en-us/library/ms190312.aspx [http://technet.microsoft.com/en-us/library/ms190312.aspx]
 for example:
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
         'Excel 12.0;Database=c:\test.xls;HDR=YES',
         'SELECT * FROM [Sheet1!$C$2])

<div>
Where does your command run - on sql server, in Excel VBA, or in standalone application?
</div>


Where does your command run - on sql server, in Excel VBA, or in standalone application?

<div>
excel Data-From other Sources- Microsoft query-SQL Command text
</div>


excel Data-From other Sources- Microsoft query-SQL Command text

<div>
<div class="content wysiwyg-content">
How I can reference to an Excel cell in an SQL Command text? Getting &nbsp;'error converting data type varchar to uniqueidentifier' <br />
<br />
exec sp_executesql N'SELECT CustomFieldEntryView.* FROM CustomFieldEntryView WHERE (DataResourceId = @DataResourceId)',N'@DataR<wbr />esourceId uniqueidentifier',@DataRes<wbr />ourceId = Sheet1!$C$2
</div>
</div>


How I can reference to an Excel cell in an SQL Command text? Getting  'error converting data type varchar to uniqueidentifier' 

exec sp_executesql N'SELECT CustomFieldEntryView.* FROM CustomFieldEntryView WHERE (DataResourceId = @DataResourceId)',N'@DataResourceId uniqueidentifier',@DataResourceId = Sheet1!$C$2

reference to an Excel cell in an SQL Command text

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.