read xml method-- faster one

R

rchiuhk

Dear all,

Is it possible for ADODB.Recordset to read xml in excel??
I have followed the code below but it prompt error when recordset open.
Error Message"???????? ??XML??????".
Do you know why???
http://www.ozgrid.com/forum/showthread.php?t=27818

Moreover, Is it possible to use xmltextreader in excel vba??
All I want to do is speed up searching a record in xml file.
Now I have done according to below. But it need iterate for each record.
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

Any Ideas in excel vba???
 
J

Joel

Try instead of Excel 8.0 use XML 1.0. XML is not an excel format and is
probably confussing. An XLS file is binary and XML is text which would be a
problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top