Toad World® Forums

Excel import fails converting data version 5.2.1.299

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.