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!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement