Results viewer cannot execute the query error

• jfloan

  SSC Veteran

  Points: 293

  More actions

  August 22, 2013 at 7:27 am

  #395349

  Hello,

  We need to copy paste data from excel into a SQL table from time to time. We have no control over the table, it is generated and given to us periodically. We are getting an error now:

  "The results viewer cannot execute a query with more than 655 columns in the project list".

  I know that the answer is, normalize the table and reduce the number of columns. Unfortunately, we have no control over the table. So is there any easy way to get data into the table under this achitecture? Not sure I want to build SSIS for this, but might I have too? I am hoping there is a workaround someone out there might be able to hand off to me.

  Thanks in advance!

• Richard Warr

  SSCertifiable

  Points: 6963

  More actions

  August 22, 2013 at 7:49 am

  #1643924

  Could you write a simple macro to create the INSERT statements in Excel and then just copy/paste them into SSMS?

  With a few columns it's an easy formula, e.g.

  +"INSERT INTO MyTable VALUES (" & a1 + ",'" & b1 & "'" etc.

  but with > 655(!) a macro would be faster.