Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: odbc load query


From   "Sergiy Radyakin" <serjradyakin@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: odbc load query
Date   Fri, 8 Aug 2008 20:48:32 -0400

Check if the Excel file is closed ~ not used by any program on your
computer or any other computer in the network. Check if you can read
other Excel files. Move/copy the file to another location and
reconfigure the driver. Does it work?

Regards, Sergiy

On 8/8/08, Murali Kuchibhotla <muralik@iastate.edu> wrote:
> 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: owner-statalist@hsphsun2.harvard.edu
> > [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Murali
> > Kuchibhotla
> > Sent: Freitag, 8. August 2008 18:33
> > To: statalist@hsphsun2.harvard.edu
> > 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/
>
*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index