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 <[email protected]> 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: [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/
>
*
* 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/
