Hi Carlo,
Tried it; doesn't work though. I still get the same error
message.Thanks for the suggestion though.
Murali
> 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/
>
Murali Kuchibhotla
Department of Economics
Iowa State University
Office:75,Heady
Phone:515-294-5452
*
* 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/
