a table updating itself with data from web?

  • Does anyone know if that's possible?

    I guess my questions are first of all:

    is it doable?

    And second how? (stored procedure and a job?)

    thanks for any insights!

  • You would need something to kick it off, but can't see why a scheduled dts package couldn't do it.

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

  • Do you mean just updating with data?

    You`d just use a Stored Proc and an ADO connection client browser side (using commands to cal the stored proc).

    Andy.

  • Specifically what are you trying to accomplish? Without knowing what the end result should be and how it should be reached I am not sure what answer you need.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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