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

Re: st: odbc load query

From   Nick Winter <>
Subject   Re: st: odbc load query
Date   Fri, 08 Aug 2008 12:56:53 -0400

I just ran into this very problem last week, and found a solution in the Statalist Archives from last July.

The bottom line is to try adding the "noquote" option to your odbc load command.

Here's the old posting:

Stata developers: would it be useful to add reference to this problem in the online help for odbc, and/or to suggest the -noquote- option as a possible fix for r(682)?

-- Nick Winter

Murali Kuchibhotla wrote:

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;


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:
Nicholas Winter                                 434.924.6994 t
Assistant Professor                             434.924.3359 f
Department of Politics         e
University of Virginia w
PO Box 400787, 100 Cabell Hall
Charlottesville, VA 22904

*   For searches and help try:

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