Connecting to Access database using ODBC

[dgudkov]

See also these topics:

How to import from accdb

Hi, New user here trying to robotize some of the boring repetitive tasks… I want to connect to an Access database through ODBC, but can’t seem to get my head around doing it properly. I have added an accdb to the ODBC data sources as a System DSN. In Easymorph, I have gotten access to the accdb file, and can see the query I want to pull from in list of tables and queries, but get various errors depending on which dialect (?) I select in the configurator… How do I fix it, so I can pull queri…

ODBC 32bit on 64bit machine

I try to connect to a 32bit Access database using ODBC. We use Win7 Enterprise 64 bit as operating system. For installation of the 32bit driver I need to start …windows\SysWOW64\odbcad32.exe. When trying to use the installed User-ODBC-driver I run into the follwoing message, indikating a problem with 32/64 bit. [image] Have you got an idea how to deal with that? Thank you.