When I used OLEDB, it takes only 2 - 3 seconds to read 3200 rows from an Excel Sheet. Now I changed to OpenXML format and now it takes more than 1 minute to read 3200 rows from an Excel Sheet.When I used OLEDB, it takes only 2 - 3 seconds
When I used OLEDB, it takes only 2 - 3 seconds to read 3200 rows from an Excel Sheet. Now I changed to OpenXML format and now it takes more than 1 minute to read 3200 rows from an Excel Sheet.When I used OLEDB, it takes only 2 - 3 seconds