Rohan
Rohan

Reputation: 177

Export Data of Sql Compact database (mdf File) to Access or Excel or CSV format

Hi i Have Used Database file for storing Data in my Application. Now I want to take backup of data in Access, Excel or in Any other Format. Thank You..

Upvotes: 0

Views: 1933

Answers (1)

sh_kamalh
sh_kamalh

Reputation: 3901

Sql Server CE files are with extension sdf.
Check this link http://exportsqlce.codeplex.com/ that will allow you to export schema and data of SqlServerCE. Once you export the data, run the output in access (after you create the database). This should make the Access database have the same data as your SqlServerCE database.

Upvotes: 1

Related Questions