How can we load the Xlsx and xls files using the same connection manager?

  • Hi

    I am using SQL Server 2008 , trying to load the data from excel files into the sql server table.I have both the type of files i.e .xls (excel 2003 format) and .xlsx (exce 2007).

    The situation is i can get any kind of file either .xls or .xlsx files and when i m creating the connection its giving option to create the connection for excel 2007 and which is not loading excel 2003 files...

    i hope it is the upgradation and it should work for the both. Any one help will be appriciated as i need it very urgent.

    Thank In Advance

  • sumankumarreddym (7/23/2009)


    Hi

    I am using SQL Server 2008 , trying to load the data from excel files into the sql server table.I have both the type of files i.e .xls (excel 2003 format) and .xlsx (exce 2007).

    The situation is i can get any kind of file either .xls or .xlsx files and when i m creating the connection its giving option to create the connection for excel 2007 and which is not loading excel 2003 files...

    i hope it is the upgradation and it should work for the both. Any one help will be appriciated as i need it very urgent.

    Thank In Advance

    Check this post. It will help you to understand how the connectors work.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

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