Export as csv or xsl file from SQL Server 2008 express R2 I am basically LAMP developer got some assignment where SQL Server is required. I have installed SQL Server 2008 R2 Express and imported backup file in it. 

Now, I want to export user table in excel or csv but not able to do that. 

Can anyone tell me how can I export table?
You'll want to look at using SQL Server Integration Services.

If you want to export a small amount of data, you can also SELECT the data in SQL Server Management Studio, and highlight / copy / paste it into Excel, or rt click save as.