query regarding Retriving specific coloumns in vb.net's dataset RRS feed

  • Question

  • Hi all

    My query is -

    I want to export the selected datacoloumns of excel sheet into vb.net's Dataset

    I am using this to get all data of excel to get in to dataset - "SELECT * FROM [Sheet1$]"

    but i want to add where clause where  I can select specific coloumns from excel sheet into dataset

    as we do in sql query  that,

    select * from table_name where condition

    so i want to include where claues in my query to select those cloumns

    help me in the same

    Thank you

    Monday, January 30, 2012 4:08 PM