CODEWITHSUNDEEP
c#.netsql-server-ce
pro3carp3
pro3carp3

Reputation: 813

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

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.

Upvotes: 3

Views: 15035

Answers (3)

Cheick
Cheick

Reputation: 2204

you can also use the the "sql server migration wizard" to convert it to sql server database and the use this tool to convert it back to a .sdf database

Upvotes: 0

ctacke
ctacke

Reputation: 67168

You might look at PrimeWorks' DataPort Wizard.

Upvotes: 2

Christopher Edwards
Christopher Edwards

Reputation: 6659

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

Upvotes: 3

Related Questions