Most SQL Server developers and DBAs work with SQL Server Management Studio (SSMS) all the time. But SSMS is a very capable tool and most users only know how to use a fraction of its features.
If you want to import data from access database to SQL Server Database using SQL server management studio this tutorial is for you. Sometime we need to import access database to sql server database. You can easily import access database into sql server easily. This tutorial covers how to import data from access database to sql server step by step.