How to import/export data in SQL EXPRESS?

Hi all,
Pls tell me how to import/export data in sql express from other types like excel,access.
Pls help.
Thank You.

Try this ,
open SQL Management Studio --> right click on database --> click on Tasks -->click on Import
--> change the source data connector to excel or Access as listed in option
The rest should be easy.
Note : Iam not sure express edition has this but worth a try.
Regards,
Sat

Hi,
There is no menu like task in SQL Express.and also no import.
Thanks
Jeen

Hi,
You can do it from Excel or from Access, if available...
Steps
From MS Access -> File -> Get External Data ->Import -> Chose ODBC Data base from the File of type combo from the dialog box [Last option]-> Create a new data source [you can use existing one also] -> Specify the server details -> Save it in your machine -> once you did the same you can see the SQL server data base objects and select the required one
Same thing you can do it in Excel also
This may help you....

For importing its ok. but wat abt exporting ?
Actually i had downloaded managment studio only.Not else anything...
Thank U.
Jeena

But how to get that component?Wer it is?Sholud i need to download it separately?
Thanks

Thank You.
Jeen

Crogram FilesMicrosoft SQL Server90DTSBinnDTSWizard.exe