Post reply

IMPORT INTO EXCEL 2016

  • January 25, 2018 at 9:51 am

    #335392

    Hi Guys, i have just been upgraded to excel 2016.  I trying to import data from SQL server into excel and it seems a little different.  I also cant seem to edit the sql code as i could in the proprieties section as per previous versions of excel. I'm also now showing 2 new tabs in excel (design and query).  I have loaded a word doc with screen shots what i am trying to achieve. If anyone can help that would be great.

  • January 25, 2018 at 11:43 am

    #1977408

    You may wish to convert the word doc to PDF. I'm terribly worried about openning word docs on my pc.

  • January 26, 2018 at 1:01 am

    #1977487

    Thanks, converted to PDF as requested.  Many thanks

  • January 29, 2018 at 6:20 am

    #1977673

    craig.jenkins - Friday, January 26, 2018 1:01 AM

    Thanks, converted to PDF as requested.  Many thanks

    Not sure this is a great idea, How about using SSRS ?

  • January 29, 2018 at 8:17 am

    #1977697

    Data Tab > queries and connections >> right click your query >edit
    New Query editor opens....Home tab > advanced editor.

    hope this helps

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • January 30, 2018 at 3:56 am

    #1977827

    If you click on Edit on the query tab you can then edit the 'Source' in the dialog box that pops up. It is over on the right hand side under query settings.

Viewing 6 posts - 1 through 5 (of 5 total)

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