Loss of data while importing into Excel

C

chs245

Hi

can anyone tell me why the following data from the xml file is not
displayed in Excel whem importing it from the GetData menu ?

file: http://www.sec.gov/Archives/edgar/data/106618/000092189503000689/kle1.xml

missing data item in Excel: <rptOwnerName>KLEIN LOUIS
JR</rptOwnerName>

Many thanks,

Oliver
Click to expand...

Hi have tried importing the data with the OpneXML command, and all the
data is there! Still curious why the Excel Import External Data drops
some of the xml fields. Anyone had the same experience ?

Oliver
 

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

Similar Threads

Connection/Refresh Control unavailable for imported XML data 0
XML from url import too long 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
import XML data...Is there a size limit on the import? 0
Inserting data from an Excel file to a database 0
Importing web data into Excel 2000 4
XML data import breaks cell formatting 0
Excel IMPORT which updates fields 0

Top