Try the command
"set memory 15000"
I had problems connecting to acces databases with more than 140000 entries,
You have to close STATA
restart it , your first command before loading any data must be the set
memory instruction
-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Murali
Kuchibhotla
Sent: Freitag, 8. August 2008 18:33
To: [email protected]
Subject: st: odbc load query
Hello,
I am having problems trying to connect to my odbc dsn. When I try to
load an excel spreadsheet through the odbc, I obtain the following message:
set debug on
odbc load , table("07-01-08") dsn("dailysnap_2008")
Connection Parameters (IN): DSN=dailysnap_2008;
Connection Parameters (OUT): DSN=dailysnap_2008;
r(682);
I have the driver for dailysnap_2008 correctly identified. Also, r(682)
suggests that I might have insufficient permission to connect to the
datasource, which is not the case here. Any suggestions? Thanks.
Murali Kuchibhotla
*
* 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/
