SQL Server Performance

Importing EXCEL 2007 Data

Discussion in 'SQL Server 2005 Integration Services' started by dineshasanka, Feb 13, 2007.

  1. dineshasanka Moderator

    TOday I got this issue, when I was asked to import excel 2007 file to database. Anyway, I was able to do this after converting that excel to 2003. Is there anyway of doing this without converitng to 2003.

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  2. satya Moderator

    Are you importing to a SQL Server database?
    if so then which version of SQL Server you are using?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. dineshasanka Moderator

    I am using SQL Server 2005 enterprise

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. satya Moderator

    I think there is a support hotfix available, might check KBAhttp://support.microsoft.com/kb/926422/ in this case.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. dineshasanka Moderator

    well, I am not getting any errors. Simply it says invalid file type. anyway, I will install this hotfix and see

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page