Importing EXCEL 2007 Data

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/

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.

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/

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.

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/