Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: Import Excel with xmluse


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Import Excel with xmluse
Date   Sat, 1 May 2010 00:24:02 +0200

<>

Consider an investment into Stat/Transfer, I would say. If you do this type
of conversion frequently, it may well be worth it, as the program can take
you direcly from Access databases to Stata datasets.


HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Leslie
Sent: Samstag, 1. Mai 2010 00:17
To: statalist@hsphsun2.harvard.edu
Subject: st: Import Excel with xmluse

Dear Stata users,

I am trying to import an Excel file that I have exported from Access.
I tried exporting the file from Access as an .xml & .xsd file and
using the xmluse command to import it directly into Stata.  But I keep
getting an "unrecognizable XML doctype" error.  Does anyone have any
suggestions?

Thank you
Leslie

xmluse g:\DataDump\qryLeslieDataDumpMUOnly.xml, doctype(excel) firstrow all

xmluse g:\DataDump\qryLeslieDataDumpMUOnly.xsd, doctype(excel) firstrow all

unrecognizable XML doctype
r(198);

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index