Unable to import Excel file,Toad SQL Server reads the worksheet but never displays the data.. (4261100)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Unable to import Excel file,Toad SQL Server reads the worksheet but never displays the data..
Description

The Import Wizard will not open and process a very large Excel .xlsx file.
The file has over 40K rows and 100 columns.
Toad for SQL Sever hangs or takes an extremely long time to open and reading of worksheet.
If the data can display the data in import wizard, the data fails to be imported.
Resolution

WORKAROUND:
Convert XLS file to CSV file and import the converted file.
STATUS: Fixed in 6.6 version of Toad for SQL Server.
Download it here.
Defect ID

TSS-1218

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title