Home > IT Answers > Database > Migrating from MS Access to SQL Server Express
SQL Server Ask the Experts
2,585 pts.
 Migrating from MS Access to SQL Server Express
Microsoft Access, SQL Server Express Edition, SQL Server migration
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?

Software/Hardware used:
ASKED: April 18, 2008  1:01 PM
UPDATED: April 18, 2008  6:28 PM
RELATED QUESTIONS
Answer Wiki:
Microsoft has an upgrade advisor available on thier website to assist in migrating from Access to SQL Server. You can find the upgrade advisor <a href="http://www.microsoft.com/sql/solutions/migration/default.mspx">here</a>.
Last Wiki Answer Submitted:  April 18, 2008  6:27 pm  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Denny Cherry
 64,505 pts.