<div>
Thanks a lot for the help. Realising this would be messy without SSMA I asked another question to see if I could programmatically use the SSMA from my app<br />
<a href="https://www.experts-exchange.com/questions/28632277/VB-net-SSMA.html?anchorAnswerId=40654322#a40654322" rel="ugc">https://www.experts-exchange.com/questions/28632277/VB-net-SSMA.html?anchorAnswerId=40654322#a40654322</a>
</div>


Thanks a lot for the help. Realising this would be messy without SSMA I asked another question to see if I could programmatically use the SSMA from my app
https://www.experts-exchange.com/questions/28632277/VB-net-SSMA.html?anchorAnswerId=40654322#a40654322 [https://www.experts-exchange.com/questions/28632277/VB-net-SSMA.html?anchorAnswerId=40654322#a40654322]

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a Windows forms application where I want my users to transfer Access tables into SQL.<br />
There are several users who don't have SSMS and only app who have to move this data.<br />
I use VB.net code with connection strings to connect to Access via ODBC and SQL using SQLClient<br />
What VB.net code would I use to transfer data from an Access table to a SQL table?
</div>
</div>


Hi

I have a Windows forms application where I want my users to transfer Access tables into SQL.
There are several users who don't have SSMS and only app who have to move this data.
I use VB.net code with connection strings to connect to Access via ODBC and SQL using SQLClient
What VB.net code would I use to transfer data from an Access table to a SQL table?

VB.net Windows Forms application Transfer data from Access to SQL

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,