Dear Peter,
there is no simple solution as there is no 64-bit ODBC driver for MS
Access, but some options are discussed here:
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.odbcclientsvr&mid=3dab8e1c-b73d-410f-b672-69dfa9200944&sloc=en-us
I would suggest to also look through their forum for ideas.
Best regards, Sergiy
On 4/10/08, Peter Jepsen <[email protected]> wrote:
> Dear Statalisters
>
> I am running Stata 10 64-bit on Vista. I am hoping to connect to an
> Access 2007 database using -odbc-. I am trying to set up a connection as
> described in the manual under -odbc-, but apparently I have no ODBC
> driver for Access, only SQL Server. An internet search seemed to
> indicate that there is no 64-bit ODBC driver for Access. Is that right?
> Do I have any alternatives, e.g. using dbase or somesuch (SQL Server,
> perhaps)? I tried to follow the plugin-faq on the Stata Website, but it
> was too advanced for my abilities - particularly since I wasn't sure
> that it would work with 64bit Stata and 64bitVista at all.
>
> Any help is very much appreciated.
>
> Best regards,
> Peter.
>
>
> *
> * 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/
>
*
* 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/