N
Nathan
All,
Thanks for the input. I ended up using Richard
suggestion. I had a bit of trouble getting an ADO
connection to the active database working. However, I was
able to just use some example code I found on
msdn.microsoft.com and it worked. I was sure that I was
doing it one of the slowest ways possible.. and this
method is much faster, by about 10x. For me, its
averaging 1.71 ms / rec for a 16 rec sample and it
decreases to 0.60 ms / rec for a 84 rec sample.
But that's enough numbers. Help files sometimes give too
many suggestions / possible methods to accomplish a goal.
Your help was very timely and pointed me to a method that
works easily.
Thanks for the help, everyone.
Nate
Thanks for the input. I ended up using Richard
suggestion. I had a bit of trouble getting an ADO
connection to the active database working. However, I was
able to just use some example code I found on
msdn.microsoft.com and it worked. I was sure that I was
doing it one of the slowest ways possible.. and this
method is much faster, by about 10x. For me, its
averaging 1.71 ms / rec for a 16 rec sample and it
decreases to 0.60 ms / rec for a 84 rec sample.
But that's enough numbers. Help files sometimes give too
many suggestions / possible methods to accomplish a goal.
Your help was very timely and pointed me to a method that
works easily.
Thanks for the help, everyone.
Nate