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/
]]>