Post reply

Queries in Excel

  • August 4, 2005 at 3:23 pm

    #90479

    I have inherited a spreadsheet that has a number, over 200, queries of SQL Server in it.  When there is an error the data is not updated.  Is there a log file somewhere that would list the errors that occur when the queries are run?  The errors seem to be time outs or not enough resources. 

     

    Thanks for the help,

     

    Steve

  • August 5, 2005 at 6:54 am

    #579973

    Why not add an err handler in the vb code that runs he queries? You could then log 'em to the server or on .log file.

  • August 5, 2005 at 7:56 am

    #580003

    I would also suggest turning any query in the spread sheet to a Sotred proc on teh server.  THis will speed up the returns. 

    Kindest Regards,
    David

    ** Obstacles are those frightening things that appear when we take our eyes off the goal. **

  • August 5, 2005 at 8:05 am

    #580012

    Good suggestions.  The code does not appear to be in VBA, it is embedded in the spreadsheet using Excel's query editor.  I do plan to move the queries to the server as suggested.  My plan was to make them views and have the spreadsheet Select <all column names> from the View. 

    But for now, I need to find the way if the query fails so it we know which one needs to be run again.

     

    Steve

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply