Author: velnias2009 | Posted on: 5/21/2010 10:29:11 AM | Views : 299

Hey I have this code
Dim myDataset As New DataSet()
        Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "dynamic\uploadedLists\" & strFileName & ";" & _
        "Extended Properties=""text;HDR=Yes;FMT=Delimited(,)"";"

        ''You must use the $ after the object you reference in the spreadsheet
        Dim myData As New OleDbDataAdapter("SELECT * FROM [" & table & "$]", strConn)
        'myData.TableMappings.Add("Table", "ExcelTest")
        m ...

Go to the complete details ...