Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: Dynamic display of SQL in Excel?

    I have WebTrends web site traffic analysis running nightly on a SQL DB server. Every month, I must hit over 50 report URLs (pages use frames) to manually caputure 3 numbers into an Excel spreadsheet.

    Can anyone provide any pointers how I might go about building a spreadsheet that could caputure/display this data automatically?

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Massachusetts, USA
    Posts
    106

    Re: Dynamic display of SQL in Excel?

    See if under Data menu...Import External Data...New Web Query

    Not sure of the particulars but it would get you started.

    Originally posted by shadowplayer
    I have WebTrends web site traffic analysis running nightly on a SQL DB server. Every month, I must hit over 50 report URLs (pages use frames) to manually caputure 3 numbers into an Excel spreadsheet.

    Can anyone provide any pointers how I might go about building a spreadsheet that could caputure/display this data automatically?

    Thanks.

  3. #3
    Join Date
    Feb 2004
    Posts
    5

    Thumbs up Re: Dynamic display of SQL in Excel?

    Thanks for your reply. That's exactly what I ended up doing. Found it by accident when I noticed the "little yellow box" that appeared when I cut & pasted data from the webpage into my spreadsheet.

    I just saved the qry file and opened it in notepad to config the values.

    This will save me HOURS of work.

    VERY cool.

    Thanks again for your reply!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •