Re: faster way to write tables?


Thanks, Paul.

I need to use this technique in 2 situations: (1) when the data must be constructed in code; (2) when I can't get SQL Server to connect to the source table (I have to use MSDASQL.1 on the input table and SQLOLEDB.1 on the output table).

I'll have a think about your suggestions, and maybe implement them with some buffering.

(P.S. I love the Macc Lads!)


.

Quantcast