Import Access data into SQL Server CE (.mdb to .sdf)

Question

I've found a few articles & discussions on how to import data from Access to SQL Server or SQL Server Express, but not to SQL Server CE. I can access both the the Access data and CE data in the VS database explorer with seperate connections, but don't know how to move the data from one to the other. (I'm using c#.) Any suggestions? Thanks.

Answer 1

You can do it using SSIS, or even in SQL Server Explorer if you are not looking to do it programmatically.