<div>
SSMA has two versions. &nbsp;Make sure that you are using the 32-bit version. &nbsp;As I recall, when you do the install, the 64-bit version ends up front and center and you have to search out the 32-bit version.
</div>


SSMA has two versions.  Make sure that you are using the 32-bit version.  As I recall, when you do the install, the 64-bit version ends up front and center and you have to search out the 32-bit version.

<div>
Here's the download link. &nbsp;I think the second option is 32-bit:<br />
<a href="https://www.microsoft.com/en-us/download/details.aspx?id=54255" rel="ugc">https://www.microsoft.com/en-us/download/details.aspx?id=54255</a><br />
Here's the options for which to download:<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/04_w14/1295371/SSMA.JPG" target="_blank" title="SSMA.JPG (81 KB)"><img alt="SSMA.JPG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/04_w14/800_1295371/SSMA.JPG" /></a>
</div>


Here's the download link.  I think the second option is 32-bit:
https://www.microsoft.com/en-us/download/details.aspx?id=54255 [https://www.microsoft.com/en-us/download/details.aspx?id=54255]
Here's the options for which to download:
SSMA.JPGhttps://filedb.experts-exchange.com/incoming/2018/04_w14/1295371/SSMA.JPG

SSMA.JPG

<div>
<div class="content wysiwyg-content">
I am trying to migrate a MS Access 2013 database to SQL Server 2008 using SQL Server Migration Assistant Version for Access 7.7 .<br />
When I browse down the MS Access DB in the UI none of the tables are showing and as a result the wizard finishes with nothing to migrate message.<br />
I have runtime installed (32 bit was the only one that would install - so have to work on the premise I have a 32 bit Office installation.<br />
The SQL Server is on a machine on the LAN and connecting to that is not a problem.<br />
<br />
Bit lost.
</div>
</div>


I am trying to migrate a MS Access 2013 database to SQL Server 2008 using SQL Server Migration Assistant Version for Access 7.7 .
When I browse down the MS Access DB in the UI none of the tables are showing and as a result the wizard finishes with nothing to migrate message.
I have runtime installed (32 bit was the only one that would install - so have to work on the premise I have a 32 bit Office installation.
The SQL Server is on a machine on the LAN and connecting to that is not a problem.

Bit lost.

Unable to Migrate MS Access 2013 using SSMA

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.