Export to Excel?

I am using SQL Server CE as a backend to a dekstop application. I would like the ability to export some of the SQL Server CE tables in my databse to MS Excel. Is this possible?

Thanks.

Mike

Save your data as CSV or XML and Excel would load it.

Export sql server express 2005 to 2000

Hi,

I"m trying to export a databse from my express 2005 to 2000 and I tried using managment studio and doesn't seem to work.

Can anybody give me some tips or links that teach me how to do that? I googled around , so far, havne't found a good solution yet.

Thanks

Hi,

How did you perform the exporting? And what's the error message as it didn't work? Or just no data had been transfered?

I managed to export data from SQL2005 database to SQL2000 in this way:

1. Open Management Studio, explore 'Databases'->right click 'Mydb'

2. Choose 'Tasks'->'Export data', and follow the steps in 'Import and Export Wizard'.