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
Ricardo Ovaldia <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: import excel-file too big
Date
Mon, 22 Aug 2011 07:36:22 -0700 (PDT)
Thank you Subrata.
However, I can not get the -odbc- to work in Stata 12. I get the following error:
. odbc load, dsn("test_file.xlsx") table("sheet1") clear
The ODBC driver reported the following diagnostics
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQLSTATE=IM002
r(682);
The file is in the working directory:
. dir test_file.*
45.0M 8/22/11 9:29 test_file.xlsx
What am I doing wrong?
Ricardo.
Ricardo Ovaldia, MS
Statistician
Oklahoma City, OK
----- Original Message -----
From: Subrata Bhattacharyya <[email protected]>
To: [email protected]
Cc:
Sent: Monday, August 22, 2011 8:34 AM
Subject: Re: st: import excel-file too big
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/
*
* 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/