• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 41
  • Last Modified:

AppendChunk and SQL 2012

I had a previous question on Experts exchange.  Here  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.
  • 2
1 Solution
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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?

al4629740Author Commented:
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?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Have you tried using this method with SQL 2012?>>

 No I have not.  Append/Get Chunk is not something that is used all that often.  However as I said, I can't think of any reason why it would not work.  The following:


  is something you may want to pass along lacking specifics on the problem.    Make sure they look at the "Notes" section at the bottom, as it lays out some of the issues that might be encountered.

  At a guess, it would have more to do with the driver being used than anything.  Nothing has changed in SQL Server 2012 in regards to field types that I'm aware of.

  But without more details, that's just a guess.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now