How to import mdb to sql server
Solution 1
Open your MS Access database, go to tools/database utilities/upsizing wizard. You're done.
Just follow the wizard's steps, make sure you have administrative rights on the SQL server, check all your steps with the integrated help for detailled table/indexes/rules upsizing.
Some database will not upsize easily, due to specific Access/Jet configuration that cannot be imported into SQL. This company has a small module to check this kind of issue and might also propose its own upsizing wizard here.
Solution 2
Microsoft Access, if I recall has a Sql upsizing wizard, atleast 2k7 does, previous versions might have it also.
Solution 3
You can also use SQL Server directly to import an Access MDB file into a SQL Server database. In SQL Server 2000, this was done using DTS. In SQL Server 2005/2008, this is done with SSIS.
Have a look here for a tutorial:
http://www.accelebrate.com/sql_training/ssis_tutorial.htm
Solution 4
If you've got an existing ODBC connection to the MS Access DB, then you can create a sql 2005 database, right click and choose Import (in Management Studio) and run through the import wizard pointing the datasource at the MS Access data connection.
Hope this helps.
Solution 5
You can use the Import wizard in the SQL server. Select the source as the MDB and the destination as your SQL server.
Admin
Updated on March 21, 2020Comments
-
Admin about 4 years
I have a vb application. Now I have developed that same vb application in Asp.net. In vb I had used MSAccess database. In asp.net I am using Sql server. Now I want to Move or copy the MSaccess database data into Sql server.