I just tried creating XML with CursorToXML to a file. That worked very quickly. I tried to import the XML into Excel, but it took twice as long as ...
oRange = oExcel.Application.ActiveSheet.Range("A3:D3")
SCAN
oRange.Value = <fieldname>
oRange = oRange.Offset(1,0)
ENDSCAN
>Look into Pivot table and Data/Import external data
>
>Mark
>
>>Hi all
>>
>>I've got about 10,000 records to dump into Excel. There are about 10 client with that many records each. As Tamar Granor puts it in her (and Della Martin's) book, "This method of populating the data ... performs well on small data sets".
>>
>>I'm wondering if there is a way to get Excel to fill a range with a chunk of XML. If so, please share some example code.
>>
>>Thanks!