Importing Stored Procedure execution in excel - New Columns not showing up

• skb 44459

  SSCarpal Tunnel

  Points: 4768

  More actions

  March 30, 2017 at 11:55 am

  #151086

  We have a stored procedure which we use to import the data in Excel using following vba
    'With ActiveSheet.QueryTables.Add(Connection:=Array(ConString1), Destination:=Range("A1"))
          .CommandType = xlCmdSql
          .CommandText = IpSQLCommand
          .FieldNames = True
          .RowNumbers = False

          .Refresh BackgroundQuery:=False
      'End With
  This has been working fine.
  Recently we added few more fields to the output of Stored Procedure.
  In the SQL studio all the fields shows up but in excel all the new fields are missing.

• Phil Parkin

  SSC Guru

  Points: 246988

  More actions

  March 30, 2017 at 12:16 pm

  #1935806

  This appears to be an exact duplicate of

  https://www.sqlservercentral.com/Forums/1867572/Importing-Stored-Procedure-execution-in-excel-New-Columns-not-showing-up

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel