How can I reffer a column in my query when using excel old db provider?

Question

      May be the most basic question but I got stuck when during data generation data bound process I have to reffer to a specific column say D in my Sheet2. I can get all Columns in Sheet2 by using Select * from [Sheet2$] but when I have to reffer to Column D I tried Select D$ from Sheet2$ but it did not work.

     Can anyone tell me what should be the exact syntext?

Nilkanth S. Desai

Answer 1

Select D from [Sheet2$]

Should work fine.

---

Lingaraj Mishra

Answer 2

Hello Mishraji,

      Thanks for your reply. I try u r suggestion with one more alternative also as Select D$ from [Sheet2$] but it did not work. Thanks for u r answer.

Nilkanth S. Desai

Answer 3

Hi Nikanth,

Welcome to MSDN Forum.

@Lingaraj's solution should work, is there an exception thrown, or the data isn't your expected?

Best Regards

---

Allen Li [MSFT]
MSDN Community Support | Feedback to us

Answer 4

If you are not using a header in the Excel Worksheet to identify the column names, then the default column names are F1, F2, F3, etc.

---

Paul ~~~~ Microsoft MVP (Visual Basic)