Home > IT Answers > SQL Server > Migrating from MS Access to SQL Server Expres...
Help

Question

  Asked: Apr 18 2008   1:01 PM GMT
  Asked by: SQL Server Ask the Experts

Migrating from MS Access to SQL Server Express


SQL Server migration, SQL Server Express Edition, Microsoft Access

I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 18 2008  6:27 PM GMT  by Mrdenny




Microsoft has an upgrade advisor available on thier website to assist in migrating from Access to SQL Server.

You can find the upgrade advisor here.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Database.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Apr 18 2008  6:28PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.