openrowset excel - Cannot resolve collation conflict for equal to operation.

• Simon-220850

  SSCrazy

  Points: 2789

  More actions

  June 5, 2007 at 9:34 am

  #116989

  Hi

  I am trying to join the contents of an openrowset query against and excel spreadsheet with a SQL Server table and am receiving the message

  "Cannot resolve collation conflict for equal to operation."

  I'd normally associate this with two databases with different collations.  Why does this happen with trying to join a Microsoft Excel spreadsheet

  Cheers

   

   

   

   

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  June 5, 2007 at 2:34 pm

  #710954

  Posting the query would be useful.

  But general suggestion - apply COLLATE inside equation:

  WHERE SomeCal COLLATE ... = AnotherVal COLLATE ...

  _____________
  Code for TallyGenerator