How to select just first column in Excel sheet with DataSet

        Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & Session("fn") & ";" & _
        "Extended Properties=""Excel 8.0;"""

        Dim myData As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
        myData.TableMappings.Add("Table", "ExcelTest")
        Dim myDataset As New DataSet
        myData.Fill(myDataset, "table1")

How can I just select the first column in the EXCEL sheet instead of all (*),
like:  ("SELECT  first_column  FROM [Sheet1$]", strConn)
LVL 16
Who is Participating?
Does the first row contain the Column Names?

If not, use this connection:

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & Session("fn") & ";" & _
        "Extended Properties=""Excel 8.0;HDR=No;IMEX=1"""

"SELECT F1 FROM [Sheet1$]", strConn

MikeMCSDAuthor Commented:
thanks Dave,
I don't have a column name for the first row.
What does the "F1" do?
The code worked, but it also selected "F1" as the first row
when I put it in a datagrid for testing.  It also selects a bunch of
blanks row after the last row and I don't know how to stop it from
doing that.
I'm not too sure about ADO .Net, but with ADO if you use HDR=No, then the column names are defaulted to F1 for A, F2 for B etc...

What does your Excel sheet look like?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.