Home Forums SQL Server 2008 SQL Server 2008 - General HELP HELP Database 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 ??? RE: HELP HELP Database 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 ???

  • October 29, 2012 at 5:56 am

    #1553687

    ...

    The database can export small sets of hundreads of records, but thousands I get this error. What is the issue.

    The issue is reported to you: 'Dave Smith' cannot be converted to INT data type.

    I guess, that some records in your "thousands" have alpha-numeric values which cannot be converted to INT.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]