We help IT Professionals succeed at work.

Convert MS Access db to MS SQL Server CE

Medium Priority
662 Views
Last Modified: 2013-11-26
I am using Visual Studio 2005 to build a mobile application. I would like to add a SQL Server CE database to the project that has the same structure (tables and relations) as an existing MS Access 2000 database. Is there a way to do this without having to manual recreate it all.

Thanks.
Comment
Watch Question

Commented:
Hello GIANTOCR,

Check to see if this can help you:

http://stackoverflow.com/questions/481719/import-access-data-into-sql-server-ce-mdb-to-sdf


Regards,

jppinto

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
havj123 and jppinto, thank you for your prompt responses. It will be this evening before I can try these out. I will do so and award points then.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.