Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums

none
Issue with excel file

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all,

    I developed 2008 SSIS package to export data into multiple excel files(.xlsx) by following the below links

    http://www.rafael-salas.com/2006/12/import-header-line-tables-into-dynamic_22.html

    http://www.rafael-salas.com/2006/12/import-header-line-tables-_116683388696570741.html

    Everything works fine. but I am not able to open Excel files that i've generated. I got an error like

    Excel cannot open the file asd.xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file

    Here is the path in Excel connection manager:

    \\abc\xyz\Files\test\a.xlsx

    Can anyone please suggest how to solve this issue

    Thanks,

    Jyo

    Thursday, May 03, 2012 6:20 PM
    |
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    As far as i know you cant use a EXCEL Object for xlsx formats.

    Please check this link

    Sincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

    Monday, May 07, 2012 5:12 PM
    |
    |

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Jyo,

    this sounds to me that you simply do not have the proper version of the MS Office or at least the Excel file. To pen it download the Excel 2010 viewer.

    Arthur My Blog

    Thursday, May 03, 2012 6:27 PM
    |
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    did you choose the right excel version in the connection manager?

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Thursday, May 03, 2012 6:35 PM
    |
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    If i generate .xls files instead of >xlsx files i can open them. Still i can't open .xlsx files after dowloading excel 2010 viewer.

    In connection manager , while  i was trying to generate .xls files i  did choose Excel 97-2003 and for .xlsx files i did choose  excel 2007.


    Thursday, May 03, 2012 7:05 PM
    |
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    If i generate .xls files instead of >xlsx files i can open them. Still i can't open .xlsx files after dowloading excel 2010 viewer.

    In connection manager , while  i was trying to generate .xls files i  did choose Excel 97-2003 and for .xlsx files i did choose  excel 2007.


    I suggest you generate the .xls files. And they can be opened just fine with any MS Office Excel just fine in most occasions.

    Arthur My Blog

    Monday, May 07, 2012 2:41 PM
    |
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    As far as i know you cant use a EXCEL Object for xlsx formats.

    Please check this link

    Sincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

    Monday, May 07, 2012 5:12 PM
    |
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Decide your by the use of to fix xls

    This article http://www.xlsfix.com will open to you a lot of tips&tricks about excel files

    Sunday, July 07, 2013 10:31 AM
    |
    |