Exporting Data To Excel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top