>Thanks for posting this Larry, I'd of never thought I could do this either before this thread... best trick I learned up in here in awhile!
Thanks.
I got the idea attending Calvin Hsai's session on COM servers at NOLA. This was for a web application report generator and I needed speed above all. Using VFP to fill an Excel spreadsheet with hundreds of records took too long (too many COM calls). With this approach (Excel/VFP COM/SQL Server), it takes about 1.7 seconds to generate the report (Dual PII 400MHz, 512 MB RAM).
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao