Hi all, my application occurs an error "Exception of type 'System.OutOfMemoryException' was thrown." when trying to import xlsx file to sql server.
Any help appreciated...Please Help this is very urgent
Code:
        strSQL = "select * from [" & ExcelSheetName & "]"
        Dim Oledbcmd As New OleDbCommand(strSQL, XLSconnection)
        Dim oledbda As New OleDbDataAdapter(strSQL, XLSconnection)
        Dim DS As New DataSet
        ProgressBar1.PerformStep()
        oledbda.Fill(DS, "DS")