Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    5

    Cool Unanswered: Import specific XLS cells from dynamic filename

    Hi
    I'm struglling with this, can anyone assist. I'd go as far as to say, there is $$ up for the solution that works.

    Here's the routine..

    1) Upload file to server - works, no problem.

    2) Extract cell ref A1-ws1 & A1-ws2 from the newly uploaded file (myXLSFileName - WHERE ProjectID = Session("strProjectID").

    3) Update tMyTable.myfield1 with A1-ws1 & tMyTable.myfield2 with A1-ws2 WHERE ProjectID = Session("ProjectID")

    All efforts greatly received!.
    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    How far have you gotten? Have you tried using a DTS package to do this?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by BigJohnson
    Hi
    I'm struglling with this, can anyone assist. I'd go as far as to say, there is $$ up for the solution that works.
    $$ for who ... you or the person that solves it. If it's for the person that solves it, put the money in escrow, then provide the details such as table layout, DDL, and a sample of desired results (in other words, look at the sticky at the top of the forum and help us to help you)

    -- This is all just a Figment of my Imagination --

Posting Permissions

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