ExcelBanter - Sql Statement for Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sql Statement for Excel (https://www.excelbanter.com/excel-programming/427554-sql-statement-excel.html)

Vikas

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

joel

Sql Statement for Excel

I would think you could do $A:$N

"vikas" wrote:

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

All times are GMT +1. The time now is 05:10 PM.