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]

Re: st: RE: Import Excel with xmluse


From   Leslie <kickinsweet@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Import Excel with xmluse
Date   Fri, 30 Apr 2010 16:48:48 -0700

Thank you.  I tried Stat/Transfer and it truncated my text fields.
That is why I exported to Excel.

On Fri, Apr 30, 2010 at 3:24 PM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>
> <>
>
> 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/
>

*
*   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