Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: odbc


From   "Patrick Mcelduff" <Patrick.Mcelduff@man.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   st: odbc
Date   Sat, 26 Jun 2004 07:52:10 +0100

Dear all


I am trying to use the odbc command to read data from an Access 
database - without any luck at all. I am stuck at the first hurdle. 
The database is called pat and the table is called cared. I thought 
the following command should work - but it doesn't. The problem is 
with dsn. 

odbc load, dsn("pat") table("cared")

Initially I had a directory path in the command but removed it and 
moved the file to the current directory.

When I type,

odbc query pat

I get a message indicating that the data source name is not found.

What am I doing wrong

Thanks in advance
Patrick
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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