Skip to content


Excel import shows success count but no data is imported

Donna Clarke asked 3 years ago
I have a map with an Excel spreadsheet as the datasource and a SQL stored procedure as the destination.
On execution, SmartConnect returns with a success count of x rows. When I check the destination, there are no records to be found. I have changed the destination to be a tab delimited text file. SC returns with a success count of x rows but only the column headings are written to the file, there is no content. I also tried a folder datasource, SC is able to read the file and move it to success.
I thought initially it may have been because the machine did not have the correct ODBC drivers (32bit), but this was not the issue.
Has anyone had this issue and if so how did you resolve it?

If you would like to submit an answer or comment, please sign in to the eOne portal.