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 at the end of May, 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   Friedrich Huebler <fhuebler@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Import Excel with xmluse
Date   Wed, 5 May 2010 10:23:15 -0400

Leslie,

If Stat/Transfer truncates your text fields they must be too long for
Stata. The maximum length of a string variable is 244 characters. See
-help limits-.

Friedrich

On Fri, Apr 30, 2010 at 7:48 PM, Leslie <kickinsweet@gmail.com> wrote:
> 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/


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