<div>
It was the db itself, I created a new db then imported the tables I wanted then did the transfer using sql server wizard with no hitch. Ive shared the points as the answer guided me to the right paths are you happy to share the points before I commit
</div>


It was the db itself, I created a new db then imported the tables I wanted then did the transfer using sql server wizard with no hitch. Ive shared the points as the answer guided me to the right paths are you happy to share the points before I commit

<div>
<div class="content wysiwyg-content">
I start the wizard and the process appears to start ok but then fails but I am not sure why. Whatever access db table I try to import to this happens. guidance would be appreciated. I have attached some screenshots and attached the report so those viewing with a mobile device may not want to assist with the question.<br />
<br />
I am on a windows machine at home using sql server express<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/02_w05/1142170/ee1.PNG" target="_blank" title="ex1 (26 KB)"><img alt="ex1" class="file-block lazyload" style="max-width: 631px;" data-src="https://filedb.experts-exchange.com/incoming/2017/02_w05/1142170/ee1.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2017/02_w05/1142171/ee2.PNG" target="_blank" title="ex2 (41 KB)"><img alt="ex2" class="file-block lazyload" style="max-width: 662px;" data-src="https://filedb.experts-exchange.com/incoming/2017/02_w05/1142171/ee2.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2017/02_w05/1142172/ee3.PNG" target="_blank" title="ex3 (13 KB)"><img alt="ex3" class="file-block lazyload" style="max-width: 606px;" data-src="https://filedb.experts-exchange.com/incoming/2017/02_w05/1142172/ee3.PNG" /></a>
</div>
</div>


ee2.PNG

ee3.PNG

ee1.PNG

I start the wizard and the process appears to start ok but then fails but I am not sure why. Whatever access db table I try to import to this happens. guidance would be appreciated. I have attached some screenshots and attached the report so those viewing with a mobile device may not want to assist with the question.

I am on a windows machine at home using sql server express




Import access table (latest access version) into sql server express table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.