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

st: odbc - load MS access queries + import access labels

From   "Daniel Mueller" <[email protected]>
To   <[email protected]>
Subject   st: odbc - load MS access queries + import access labels
Date   Mon, 10 Jan 2005 11:36:00 +0100


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):
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"
( Any news on

Thakns in advance,

*   For searches and help try:

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