Re: st: Stata 11 (MS Windows), selecting data source (e.g. MS Access file) during ODBC-import via menu

[kcrow@stata.com (Kevin H. Crow)]

Sebastian Krimm <sebastian.krimm@kuei.de> reported that the Access ODBC data
source import menu item is not working:

> I noticed an odd change in the behavior of Stata 11 compared to the previous
> version when it comes to importing data via ODBC. Let's assume I have a MS
> Access file somewhere which I want to import using "File" -> "Import" ->
> "ODBC data source". In Stata 10, I then select "MS Access Database -
> Microsoft Access Driver (*.mdb, *.accdb)" as DSN and a dialogue pops up in
> which I can navigate to the specific file. In Stata 11 the dialogue to
> navigate to the file does not appear. I found this phenomenon on various
> machines running on Windows XP and Windows Vista (German 32-bit versions).
> Does this happen on other systems as well?
>
> Of course you can first add a new user-DSN that points to the specific file
> you want to import in the Windows Control Center, but that's quite a hassle
> if you deal with different files regularly. I also found that I could add
> the path to the file when I import using odbc load like
> 
> odbc load, dsn("MS Access Database;DBQ=c:\path\to\file.mdb") table(table1)
> 
> However it would be more comfortable to use the menu and have a dialogue to
> select the file. Does anyone have any idea how to get the latter back?

This affects Stata for Windows on all platforms.  A fix to the dialog
will be released in the next ado file update.

Kevin

> Hello everyone,
> 
> I noticed an odd change in the behavior of Stata 11 compared to the previous
> version when it comes to importing data via ODBC. Let's assume I have a MS
> Access file somewhere which I want to import using "File" -> "Import" ->
> "ODBC data source". In Stata 10, I then select "MS Access Database -
> Microsoft Access Driver (*.mdb, *.accdb)" as DSN and a dialogue pops up in
> which I can navigate to the specific file. In Stata 11 the dialogue to
> navigate to the file does not appear. I found this phenomenon on various
> machines running on Windows XP and Windows Vista (German 32-bit versions).
> Does this happen on other systems as well?
> 
> Of course you can first add a new user-DSN that points to the specific file
> you want to import in the Windows Control Center, but that's quite a hassle
> if you deal with different files regularly. I also found that I could add
> the path to the file when I import using odbc load like
> 
> odbc load, dsn("MS Access Database;DBQ=c:\path\to\file.mdb") table(table1)
> 
> However it would be more comfortable to use the menu and have a dialogue to
> select the file. Does anyone have any idea how to get the latter back?
> 
> Kind regards
> 
> 
> Sebastian
> 
> --
> Sebastian Krimm
> Mail: sebastian.krimm@kuei.de
> 
> *
> *   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/