How can I convert MS Access 2003 (2000 file format) to Sql Server Express 2014?

1

I've been searching for the past two days on how to get this conversion done, but every suggestion I've seen yields no effective results.

I've installed Sql Server Express 2014 and have verified that I can log into it successfully.

Here is what I've tried:

  • UPSIZE WIZARD: I go to "Tools > Database Utilities"

enter image description here

Then to the Upsizing Wizard. I select the appropriate installation of Sql Server Express (2014), select "Create new database," name the new database, and then click "Next," but it tells me, "The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data source."

enter image description here

  • MICROSOFT SQL SERVER MIGRATION ASSISTANT FOR ACCESS: I've tried this approach and gone through the wizard:

enter image description here

but when I add the .mdb files (which open fine in Access 2003 (though they're in 2000 format, I think), and then login to SQL Server 2014:

enter image description here

It just tells me that there is nothing to process and then no information gets populated into any new tables:

enter image description here

I have searched for the error "There is nothing to process" in regards to the Migration Assistant error I keep getting but I've only found,

This link: https://support.microsoft.com/en-us/kb/2020729?wa=wsignin1.0 - which seems to only pertain to the assessment report;

This link: http://www.experts-exchange.com/questions/28433397/Why-does-Microsoft-SQL-Server-Migration-Assistant-fail-with-There-is-nothing-to-process-error-message.html - which seems to hint at 64-bit/32-bit confusion, which I'm 64-bit and when I try the 32-bit version, it freezes.

I'm not sure what else to try or what I'm doing wrong, but any other search I've done online offers me no additional help. Is there any way to convert .mdb files to the appropriate SQL Server Express (2014) files that I need?

VoidKing

Posted 2015-05-21T13:44:55.240

Reputation: 344

1

The 10+ years of files differences are what's getting you. Convert your Access 2000/2003 DB to an Access 2007+ file first. You can probably grab a trial copy of Access 2013 if need be.

– Ƭᴇcʜιᴇ007 – 2015-05-21T13:54:46.437

@Ƭᴇcʜιᴇ007 Thank you, I'll try that today and let you know how it goes. – VoidKing – 2015-05-21T18:41:21.623

@Ƭᴇcʜιᴇ007 Well, I finally got all of my mdb files converted to accdb, but unfortunately, that doesn't help (I did it in MS Access 2010). It still just says "there is nothing to process." Is there a separate tool I can use? MS SQL Server Migration tool is a piece... – VoidKing – 2015-05-27T19:59:04.373

Answers

0

If you are on 64 bit windows, by default the ODBC will call the 64 bit tool, so if you're using 32 bit OFFICE access then call the 32 bit ODBC tool at C:\WINDOWS\syswow64\odbcad32.exe then use SQL Server Native Client 11

user563123

Posted 2015-05-21T13:44:55.240

Reputation: 1

1Does this address what the OP is asking? – Abraxas – 2016-02-24T18:23:26.720

0

You can try "Viobo Access to MSSQL Data Migrator"
https://www.cheapsoftwaremarket.com/products/business-finance/viobo-access2mssql.html

I have used the demo version to convert small Access 2003 file to MSSQL 2005, it was OK.
I don't know if it does support MSSQL 2014, but you can try.

ITProStuff

Posted 2015-05-21T13:44:55.240

Reputation: 389

Asked: 2015-05-21T13:44:55.240

Viewed: 1 041 times

Active: 2019-08-08T18:59:54.833