You need to sign in to do that
Don't have an account?
dgrissen
Batch Insert example in VB 6 or VBA?
Hi,
Can anyone help me out with a good example of a batch insert call in VB 6 or VBA? Also, code to control the insert call in sizes of 200 would really help.
Thanks!
Darrell
some (lots of) VBA code here to do batch inserts, download the add-in, install it and open the VBA environment within Excel,
look for the sub insert_range() in the Module "s_force"
http://sforce.sourceforge.net/excel/
http://sforce.sourceforge.net/excel/downloads.htm
you will have to rip out a bunch of stuff to simplify the code, much of this code is spent on working with cells and ranges, this may not be interesting (or too much work) if you are using Access or Word...
Mike