Mike Yearwood
Toronto, Ontario, Canada
I guess I have to be more specific. I know I can CursorToXML to create a file and import it into Excel. I was hoping to avoid programmatically formatting the sheet, so the user could have some control. I was asking for an example of populating a range with the XML, so I could avoid file i/o.
What did you think I meant?
>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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only