>Cetin,
>
>Thanks for you reply! I like your SaveAs() idea. It's simple and very fast! I've changed my original wrapper to use your idea. It runs almost as fast as the native COPY TO command. As far as the Excel row limitation is concerned, I don't care in my case and simply return an error code. I currently create a lot of pivot tables using automation. Should I ever run into this limitation (65K), I believe it's better to keep the data external anyway.
>
Daniel,
Glad it helped. Just an addition to code. Instead of hardcoding 65536 into code I suggest you get it from Excel (see lnMaxRows in second code sample). It might increase in Excel20xx :) Since Excel object is ready I think that portion would just get milliseconds.
Cetin