View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vikas Vikas is offline
external usenet poster
 
Posts: 7
Default Sql Statement for Excel

Hi,

I am doing oledb connection with excel from my ASP.NET application. I am
writting query to select some coulmn.
Query is like this.

Select [Fund],[statement$ Details], [Currency Hit$] From Sheet1 $ A1:N30

Instead of coulmn name, can i give the coulmn name ???

Ex:- Select A1, K1,P1,N1 From Sheet1 $ A1:N30