• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

How to select just first column in Excel sheet with DataSet

For:
        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)
0
MikeMCSD
Asked:
MikeMCSD
  • 2
1 Solution
 
flavoCommented:
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"""

Then:
"SELECT F1 FROM [Sheet1$]", strConn

Dave
0
 
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.
0
 
flavoCommented:
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?

Dave
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now