Importing EXCEL 2007 Data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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/

]]>