Re: st: ODBC, Stata 11 and Windows 64 bit

[Simon <scmoore.lists@googlemail.com>]

Thank you, that is perfect!

For info - I've written a short batch file that calls the 32 bit version:

"C:\Program Files (x86)\Stata11\StataMP.exe" /e do C:\Data\import.do

and stuck

	odbc list
	odbc query "access_data"
	odbc desc "Survey"
	odbc load, table("Survey")
	save "C:\Data\imported.dta", replace

into the import.do file. This seems to work well for me.

Thanks again
Simon


On 21/12/2009 21:41, Kevin H. Crow wrote:
> Simon Moore<scmoore.lists@googlemail.com>  asked about using the
> -odbc load- command to load Access files on a 64-bit Windows
> machine:
>
> > I've just upgraded to Stata/MP 11.0 for Windows (64-bit x86-64) on
> > Windows 7.
>
> > I was on Windows XP with Stata 10 and used -odbc load- to load MS Access
> > tables into Stata through registering the Access mdb file as an ODBC source.
>
> > Now, however, when I use C:\Windows\SysWOW64\odbcad32.exe to do the same
> > thing I get "[Microsoft][ODBC Driver Manager] The specified DSN contains
> > an architecture mismatch between the Driver and Application" from -odbc
> > query-
>
> > I've spent a fair bit of time on google and bing and have not found
> > anything that appears to help. Can anyone here offer any help?
>
> Microsoft has not developed a 64-bit Access or a 64-bit Excel ODBC driver.
> The workaround for Simon is to add his Access (or Excel) datasources to the
> 32-bit Windows ODBC driver manager (C:\Windows\SysWOW64\odbcad32.exe) and use
> 32-bit Stata for Windows to load his data.  Since Simon has already added his
> datasources to the 32-bit ODBC driver manager the only step Simon has left is
> to download the 32-bit Stata for Windows executable at the below URL to his
> Stata install directory and use 32-bit Stata to load his data.
>
>          http://www.stata.com/support/updates/stata11/win/
>
> Simon can -save- the data from 32-bit Stata and -use- it in 64-bit Stata
> if he prefers to perform his analyses in 64-bit Stata.
>
> Kevin
> kcrow@stata.com
> *
> *   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/