You have to login in order to post a reply to this topic.

1 reply [Last post]
Tue, 05/04/2010 - 14:04
ODBC Connection for Access Excel in 64bit Machines
D.M.Altizer
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 01/12/2010
Posts: 204

 After doing some investigation about the "Execute SQL Statement" action in 64bit machines, it seems that you cannot connect to Access or Excel with it. According to some forums that I checked the reason is that Microsoft did not release a 64bit Jet Engine yet. I have sent an email to the support department and there seems to be a work around in order to do that. This workaround involves connecting a SQL server express (64 bit) with Access (32 bit). Does anyone know how exactly can I do that? If it is possible, I could really appreciate the exact steps that are required to do that.

Thanks,
cheers!

__________________

==Dedicated Automation Solutions==

__________________

==Dedicated Automation Solutions==

Top
  • Quote
Tue, 05/04/2010 - 14:44
#1
Thomas Minitsios
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 07/16/2009
Posts: 34
Re: ODBC Connection for Access Excel in 64bit Machines

I did not try the solution with SQL Server and Access, but you can try the beta drivers that you can find here.

Top
  • reply
  • quote