I'm running Toad Data Point 4.3.0.718 and cannot duplicate the problem my team is having with TDP 5.2.1.229.
When we import an excel file with data type varchar to a column type varchar in MS SQL 2008 we get the error:
"Conversion failed converting the varchar value 'blah blah' to data type int."
They get this failure on both import to existing and import to new table. We are importing nvarchar to nvarchar and it thinks the destination is int when it is actually nvarchar.
They can make it work if they export to a .CSV file, but that adds steps. Our company no longer installs 4.3 so I can't install the older version for them. My version works even with formulas while the new version does not. We removed formulas, saved as xlsx, xls etc, Only CSV works for the newer version.
I am trying to track down the support request but cannot find it and I don't have the support # that was opened. Are you encountering this issue in the latest product - Toad Data Point 5.5 ?
Was able to get 5.5 sooner than expected, and yes I am still receving the same error. Table is created as varchar data type, but for some reason on import it is trying to convert it to int.
Conversion failed when converting the varchar value 'AB8717' to data type int.
I experienced this last week, so it seems to still be an issue. And Yes - I did try sorting data to begin with an alpha string. But still failed. Can someone from Quest advise if there is a workaround for this ?
Thanks!
FYI - my Toad Data Point version is 6.1.0.40 (64 bit)
We are using Version "Toad for SQL Server Subscription" with Version Number 8.0.0.65 and we are facing the same issue while trying to import data in a existing table from .xlsx-File. Although the target column is set to nvarchar, the import wizard tries to convert the values of the excel-file into int. Therefore the import fails with an convertion error. Is there any official statement to this bug?
