Greetings!
Two -odbc- questions (using an up-to-date Stata and Win XP):
1. Is it possible to load queries done in MS access into Stata? I am able to
read in all the tables using -odbc-, but can't see the MS access queries
after -odbc query-. I tried to insert the sql statement that generates the
queries with:
. odbc load, exec("sql.txt") dialog(complete) clear
but receive error r(682). The debug statement tells me:
--
Connection Parameters (IN): DSN=AL_village_survey;
Connection Parameters (OUT):
DSN=AL_village_survey;DBQ=F:\DBMS\albania\AL_village_survey.mdb;DriverId=25;
FIL=MS Access;MaxBufferSize=2048;Pa
> geTimeout=5;
[Microsoft][ODBC Microsoft Access Driver] Invaid SQL-request; 'DELETE',
'INSERT', 'SELECT' or 'UPDATE' expected.
--
2. Did anybody find out how to transfer the variable description from MS
access as labels into Stata using -odbc-? (I found an older posting that
assumes this to be "a deficiency in Access drivers"
(http://www.stata.com/statalist/archive/2003-05/msg00117.html). Any news on
that?
Thakns in advance,
Daniel
*
* 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/
