Excel 2007 and SqlServer sp2

hellow all,

i installed SqlServer 2005 sp2 on my server.

now, how do i import excel 2007 files in SSIS? i don't have office 2007 installed on my computer, but i've got some .xslx that i would like to try ro import. i tried to create an OLEDB connection, but i don't know which provider to choose.

anyway, can i do it without the sp2 or office 2007 installed on my server?

thanks for tour reply!

Data Sources/Microsoft Office (2007) - ssis
(http://ssis.wik.is/Data_Sources/Microsoft_Office_(2007))|||

thanks, the link is very helpfull.

i downloaded the example package but when i try to see the connection manager's configuration- i'm getting this massage:

"The specified provider is not supported. Please choose different provider in connection manager."

it is probably because i don't have office 2007 installed on my computer.

is there a way to get only the ACE provider without installing office 2007?

|||BTW, why is my thread icon grey? (while everybody else's is green or red?)|||That is a way to tell you which threads you have already visited (open)