Post reply

SQL -> Excel

  • April 25, 2016 at 3:38 pm

    #400070

    Can I get an article that shows how to connect to an Excel sheet and read data. Feel free to make this a 2 or 3 part piece. separate articles

    PArt 1 - use a linked server

    Part 2 - use openrowset

    part 3 - implications, maybe show issues with locking or performance from the server.

  • April 26, 2016 at 8:17 am

    #1874638

    Oooo.... I've got an awesome one that automatically adjusts for changes in the spreadsheet with no changes to the code. Have done a presentation on it a couple of times. I'm almost done with one for RAND(X) to add to David Poole's. Trying to get back into writing articles on a bit more regular basis and whether or not anyone picks up on this one, I'll also take this one on.

    Shifting gears, I still can't paste in the contribution center. Am I the only one with that problem? If so, any hints on what might be wrong with my machine.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 26, 2016 at 9:02 am

    #1874661

    Email the article(s), and feel free to focus separate pieces on a smaller part.

    The problem isn't with your machine. Probably in the chair in front of it.

  • April 26, 2016 at 4:19 pm

    #1874818

    Steve Jones - SSC Editor (4/26/2016)

    Email the article(s), and feel free to focus separate pieces on a smaller part.

    The problem isn't with your machine. Probably in the chair in front of it.

    Probably not, wise guy. 😉 Copy from Word and paste using your WORD paste icon has always worked for me in the past. It doesn't now and hasn't since the bloody SPAM eliminator that doesn't actually work properly started eliminating my posts.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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