<div>
Familiar with the method and I can't think of any reason it would not work with a later version of SQL.<br />
<br />
What exactly is the problem? &nbsp; Do you get any kind of error message? &nbsp;Also, are you using a different version of Access as well? &nbsp;If so, what version and is it O365 or a traditional perpetual install?<br />
<br />
Jim.
</div>


Familiar with the method and I can't think of any reason it would not work with a later version of SQL.

What exactly is the problem?   Do you get any kind of error message?  Also, are you using a different version of Access as well?  If so, what version and is it O365 or a traditional perpetual install?

Jim.

<div>
No error message that I know of other than that's what I was told.... I wish I could tell you more. &nbsp;Have you tried using this method with SQL 2012?
</div>


No error message that I know of other than that's what I was told.... I wish I could tell you more.  Have you tried using this method with SQL 2012?

<div>
<div class="content wysiwyg-content">
I had a previous question on Experts exchange. &nbsp;<a href="https://www.experts-exchange.com/questions/29092897/writing-and-reading-files-from-remote-locations-over-the-internet-in-VB6.html" rel="ugc">Here </a> &nbsp;In that solution, I arrived at the notion that using AppendChunk would help me load data into SQL. &nbsp;I was told by one of our programmers that using AppendChunk with later versions of SQL does not work. &nbsp;Is anyone familiar with this method in VB6 and what versions this works with in SQL...if there really is any limitations?<br />
<br />
We are currently utilizaing SQL 2012 and I know we have not tried it yet, but perhaps I may ask first to see if one of the experts here knows if there is a limitation.
</div>
</div>


I had a previous question on Experts exchange.  Here  (https://www.experts-exchange.com/questions/29092897/writing-and-reading-files-from-remote-locations-over-the-internet-in-VB6.html)  In that solution, I arrived at the notion that using AppendChunk would help me load data into SQL.  I was told by one of our programmers that using AppendChunk with later versions of SQL does not work.  Is anyone familiar with this method in VB6 and what versions this works with in SQL...if there really is any limitations?

We are currently utilizaing SQL 2012 and I know we have not tried it yet, but perhaps I may ask first to see if one of the experts here knows if there is a limitation.

AppendChunk and SQL 2012

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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.