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
Friedrich Huebler <[email protected]>
To
[email protected]
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 <[email protected]> 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 <[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/