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?
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?