Move Access Data To Sql Server Database. As time passes the Database applications increase in size and complexity too. To do this run the SQL Server Import and Export Wizard in SQL Server Management Studio to import your Access tables into a SQL Server database.
The Upsizing Wizard moves database objects and the data they contain from an Access database to a new or existing SQL Server database. Open SQL server management studio and connect it to the database server you wish to export Access database to SQL. The Upsizing Wizard lets you scale up Access database tables to a new or existing Microsoft SQL Server database.
When you migrate your data to SQL Server you are also moving from a file server to a client-server database model of computing.
Typically you use file data sources also called DSN files to add a connection string in which case the FILEDSN keyword is used on the connection string or stored in the registry in which case the DSN keyword is used. Under databases make a right click and choose New Database. In the Edit Property Value dialog box enter the database password. SQL Server is a more robust database management system than Access.