I searched for some time and I got an answer.

In Sql Server 2005 Express the import export wizard does not show in the MS Sql Server Management Studio but can be used from.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe.

I was able to export data in excel.

Hope this helps

Marisha