Sql Statement for Excel

V

vikas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA SQL Select for Column Name 1
Excel VBA help: Text file formatting 19
Using SQL command to access Excel 4
Varioable in SQL statement 4
SQL not importing records from ACCDB 2
Imprt data from SQL based on cell input 3
Problem with code used in other countries 5
Connection from Excel to SQL 6

Top