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: import excel-file too big
From
Subrata Bhattacharyya <[email protected]>
To
[email protected]
Subject
Re: st: import excel-file too big
Date
Mon, 22 Aug 2011 19:04:10 +0530
Hi Ricardo,
You might want to try -odbc-.
Regards,
Subrata
On Mon, Aug 22, 2011 at 7:00 PM, Ricardo Ovaldia <[email protected]> wrote:
>
>
> 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/
*
* 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/