Connecting to Access database using ODBC

[reynsnivea]

Hi

I am relatively new to using ODBC connections.
Is it possible to explain in detail how to connect to an Access database using ODBC from EasyMorpgh ?

Kind regards !

[andrew.rybka]

Hi

Most likely you will have to use “Custom SQL” mode of “Import from database” action to import data from Access DB.

1. Make sure that your system has an Access database ODBC 64 bit driver installed.
2. Open Windows’ ODBC Data Source Administrator (64 bit version) and a new data source with that driver (or find an appropriate data source among the existing ones).
3. Go to EasyMorph, open Connector manager and create a new SQL\ODBC connector:
   a. Select created or previously existing data source in Data source combobox.
   b. Select SQL:2003 in SQL dialect combobox.
   c. Fill in User and Password options.
4. Use created connector in “Import from database”. Try to use “Visual” mode. If it will not work correctly with Access DB connector, switch to “Custom SQL” mode.

Regards,
Andrew

[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.