Importing Access Database into SQL Server 2012

Sign in to leave a comment.

• TC

  tom cooper6y agoPosted Aug 26, 2020, 1:30 PM

  Hello, thanks for the article, i tried to migrate my Access database but got many errors about incorrect data type and syntax error at or near, so I was forced to look for something else and i found dbconvert for access and ms sql (https: //dbconvert.com/access/mssql/) which migrated all my tables and queries without any errors.
• 

  Ramon Quintana7y agoPosted Jul 4, 2019, 12:54 PM

  Hi, i followed these steps but i got incorrect format in numeric fields after import the table from access to sql server, for example: in Access i have 54.000,32 a value but once in sql i got 54000,32 i need the same format like in Access is in..some help??
• VR

  valmikeshwar reddy10y agoPosted Sep 26, 2016, 3:21 AM

  Good one helped
• 

  Hari Shanker10y agoPosted Apr 13, 2016, 2:17 AM

  Nice article
• 

  Rohatash Kumar14y agoPosted Oct 28, 2012, 11:01 PM

  I will try to do that in My next article. Mskommik MiriaM
• MM

  Mskommik MiriaM14y agoPosted Oct 24, 2012, 4:50 PM

  Many Thanks : Helpful ARTICLE : May GOD Bless You&Your Work. Sir can we import access database in SOL server through ASP.Net. If Yes, plz explain me how can i implement this..? It will help me a lot . Ms kommik e-mail = [email protected]
• 

  Swati Agarwal14y agoPosted Oct 15, 2012, 6:14 AM

  Sir can we import access database in SOL server through ASP.Net. If Yes, plz explain me how can i implement this.. It will help me a lot......
• 

  Rohatash Kumar14y agoPosted Oct 4, 2012, 3:36 AM

  Thanks Kamal.I will do it in my next article.
• 

  Kamal Rawat14y agoPosted Oct 4, 2012, 12:15 AM

  @milan das: you can use SSMA Services to migrate everything including Views as well.
• 

  Rohatash Kumar14y agoPosted Sep 26, 2012, 3:30 AM

  Thanks. Deepak
• 

  Deepak Middha14y agoPosted Sep 26, 2012, 3:03 AM

  Nice Article sir.
• 

  Rohatash Kumar14y agoPosted Sep 25, 2012, 5:55 AM

  Thanks. Manish
• MD

  Milan Das14y agoPosted Sep 22, 2012, 6:03 AM

  Hi Rohatash, Sometimes back i have tried to import the Access database to Sql server using the same process that you have followed & everything went fine but the problem i faced is that the Ms-Access Queries got formed as table in my Sql Database,So Is there any way that we can import these "Ms-Access Queries" to Views in the Sql Database?
• 

  Manish Sharma14y agoPosted Sep 22, 2012, 3:16 AM

  nice article..a deep information on SQL server ...