Error is displayed within the excel sheet the database has exported the data into. Only quater of the data that was selected is actually exported at at the top of the excel sheet the database has exported the data to I have an error Microsoft SQL Native Client error '80040e07', Conversion failed when converting the nvarchar value 'Dave Smith' to data type int. /include/aspfunctions.asp, line 1243 ???
I have copied the following Code below the error is refering to :
if IsIdentical(dDebug,true) then response.write sSQL & "
Set asp_rs = server.CreateObject("ADODB.Recordset")
asp_rs.Open sSQL,conn // line 1243 for ref //
The database can export small sets of hundreads of records, but thousands I get this error. What is the issue.