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]
st: import excel-file too big
From
Ricardo Ovaldia <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: import excel-file too big
Date
Mon, 22 Aug 2011 06:30:37 -0700 (PDT)
Hello,
I wrote an -do- file that first imports a series of excel sheets into Stata using the -import- command.
However, some of the sheets are too big and I get the corresponding error message "File too big".
I can convert the sheet to a tab delimited txt file and use -insheet- to import. That works, but this is tedious because I have lots of files and they will change from time to time.
Is there a way (code) to create the tab delimited txt file from inside the -do- program? Or does anyone have an alternative that can be automated?
Thank you,
Ricardo
Ricardo Ovaldia, MS
Statistician
Oklahoma City, OK
*
* 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/