Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: Import Excel with xmluse
From
Leslie <[email protected]>
To
[email protected]
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 <[email protected]> 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: [email protected]
> [mailto:[email protected]] On Behalf Of Leslie
> Sent: Samstag, 1. Mai 2010 00:17
> To: [email protected]
> 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/