none
Export to Excel : Excel version 2013 & 2016 are missing RRS feed

  • Question

  • Hi all,

    I am trying to export to excel from SQL Server 2014.

    I want to export to 2013 or higher version of excel but in the dropdown of Excel version it is not showing the 2013 and 2016.

    Can someone please help to fix this problem. I have office 365 of my computer.

    Thanks & regards,

    Afreen

    Thursday, August 8, 2019 6:26 PM

Answers

  • Hi Yitzhak,

    I installed this but still not seeing the Microsoft.ACE.OLEDB.12.0

    I dont know what I am missing :(

    What do you think?

    Regards,

    Afreen


    Afreen

    Hi Afreen,

    Please refer to Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Afreenraja Wednesday, August 14, 2019 7:57 PM
    Wednesday, August 14, 2019 9:27 AM
  • Hi Afreen,

    Finally. :)

    Glad to hear that everything is working for you now.

    You learned that there no need in Excel to be installed, just Microsoft ACE OLEDB provider.

    Please don't forget to click "Mark as Answer" the response(s) that resolved your issue. This can be beneficial to other community members reading this thread.

    • Marked as answer by Afreenraja Wednesday, August 14, 2019 7:57 PM
    Wednesday, August 14, 2019 7:48 PM
  • Yes.

    Thanks Yitzhak.

    Appreciate your help.

    Regards,

    Afreen


    Afreen

    • Marked as answer by Afreenraja Wednesday, August 14, 2019 7:57 PM
    Wednesday, August 14, 2019 7:57 PM

All replies

  • Hi there,

    It is not clear how you are trying to export data to MS Excel. Please share a screen shot.

    For SSIS, you need to install one of the Microsoft ACE OLEDB providers.

    Links:

    Thursday, August 8, 2019 7:07 PM
  • Hi Yitzhak,

    Thanks for the response.

    I installed the above give ACE, but its still not showing Excel 2013 or 2016 as a version to export.

    Am I missing something?

    Regards,

    Afreen

    Thursday, August 8, 2019 8:12 PM
  • The Excel version shown in the Excel destination is bound to the version of SSIS in use.

    Just use whatever, any newer Office versions are backward compatible and can thus open any older Excel files just fine.


    Arthur

    MyBlog


    Twitter

    Thursday, August 8, 2019 8:19 PM
    Moderator
  • Hi Afreenraja,

    It is not clear how you are trying to export data to MS Excel.

    Please share a screen shot.

    Here is my environment. Right mouse click on the Excel Connection-> Properties.

    By the way, as ArthurZ already pointed out, starting with MS Excel 2007 and later, *.xslx file format is the same.




    Thursday, August 8, 2019 8:30 PM
  • Hi Afreen,

    May I know what's the version of your SSDT?

    According to my test, SSDT2017 can use Excel 2013 and 2016.Please update to SSDT2017.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Friday, August 9, 2019 2:35 AM

  • Afreen

    Friday, August 9, 2019 1:14 PM
  • Hi Yitzhak,

    I have attached the screenshot and see it is not showing excel 2013 or 2016 as option in dropdown.


    Afreen

    Friday, August 9, 2019 1:15 PM
  • Hi Mona,

    Thanks for the response.

    I have the same version of SSDT installed on my machine.

    What could be the other reason?

    Thanks & regards,

    Afreen


    Afreen

    Friday, August 9, 2019 1:17 PM
  • Hi Afreen,

    Please run the following command in SSMS and share its outcome:

    -- 0. Check what OLEDB providers are installed
    -- Microsoft.ACE.OLEDB.12.0 and
    -- Microsoft.ACE.OLEDB.15.0 in particular
    EXEC master.dbo.sp_MSset_oledb_prop;

    On my machine the wizards shows the following, after clicking on the dropdown:


    Friday, August 9, 2019 2:01 PM
  • Hi Yikzhak,

    Please find attached the outcome of the command:


    Afreen

    Friday, August 9, 2019 4:53 PM
  • Hi Afreen,

    You need to install 64-bit edition of the Microsoft ACE OLEDB provider.

    -- 0. Check what OLEDB providers are installed
    -- Microsoft.ACE.OLEDB.12.0 and
    -- Microsoft.ACE.OLEDB.15.0 in particular
    EXEC master.dbo.sp_MSset_oledb_prop;

    On my machine shows the following:

    Friday, August 9, 2019 5:00 PM

  • Afreen

    Hi Afreen,

    May I know what is the version of your Excel?

    Please refer to this link to see the version of Excel.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, August 12, 2019 9:05 AM
  • Hi Yitzhak,

    Thanks I will try this again.

    Regards,

    Afreen


    Afreen

    Tuesday, August 13, 2019 7:02 PM
  • Hi Mona,

    Please find below the screenshot of the excel version:


    Afreen

    Tuesday, August 13, 2019 7:27 PM
  • Hi Afreen,

    The Excel version is irrelevant.

    What is important is 64-bit edition of the Microsoft ACE OLEDB provider.

    -- 0. Check what OLEDB providers are installed
    -- Microsoft.ACE.OLEDB.12.0 and
    -- Microsoft.ACE.OLEDB.15.0 in particular
    EXEC master.dbo.sp_MSset_oledb_prop;

    Run it in SSMS and share the outcome's screen shot like I did on my machine.

    Also, make sure that you are launching 64-bit version of the wizard. On my machine it is as follows:

    OS Start button --> Microsoft SQL Server 2017 --> Microsoft SQL Server Import and Export Data (64-bit)


    Tuesday, August 13, 2019 7:38 PM
  • Hi Yitzhak,

    I installed this but still not seeing the Microsoft.ACE.OLEDB.12.0

    I dont know what I am missing :(

    What do you think?

    Regards,

    Afreen


    Afreen

    Tuesday, August 13, 2019 7:41 PM
  • Hi Afreen,

    • I provided you links to 3 different versions of the ACE OLEDB provider at the very beginning of this thread. You can try to install 64-bit version of all 3 of them. They can coexist on the same machine.
      It is possible that you installed 32-bit ACE, and that's why it doesn't show up in SSMS.
    • By the way, where is your SSMS screen shot?


    Tuesday, August 13, 2019 7:44 PM
  • Hi Mona,

    Please find below the screenshot of the excel version:


    Afreen

    Hi Afreen,

    Please try to update to 2016.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, August 14, 2019 9:24 AM
  • Hi Yitzhak,

    I installed this but still not seeing the Microsoft.ACE.OLEDB.12.0

    I dont know what I am missing :(

    What do you think?

    Regards,

    Afreen


    Afreen

    Hi Afreen,

    Please refer to Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Afreenraja Wednesday, August 14, 2019 7:57 PM
    Wednesday, August 14, 2019 9:27 AM
  • Hi Yitzhak,

    Thanks.

    It worked for me when I select 64 bit version of import/export.

    Thanks & regards,

    Afreen


    Afreen

    Wednesday, August 14, 2019 7:39 PM
  • Hi Afreen,

    Finally. :)

    Glad to hear that everything is working for you now.

    You learned that there no need in Excel to be installed, just Microsoft ACE OLEDB provider.

    Please don't forget to click "Mark as Answer" the response(s) that resolved your issue. This can be beneficial to other community members reading this thread.

    • Marked as answer by Afreenraja Wednesday, August 14, 2019 7:57 PM
    Wednesday, August 14, 2019 7:48 PM
  • Yes.

    Thanks Yitzhak.

    Appreciate your help.

    Regards,

    Afreen


    Afreen

    • Marked as answer by Afreenraja Wednesday, August 14, 2019 7:57 PM
    Wednesday, August 14, 2019 7:57 PM