Import MS Access Database file (.accdb)

[paulgupta]

How can we import a later version (2007 and beyond) Microsoft Access (.accdb) file? 

During import, under "Resolve File Type --> Read it as a built in type", there is not category for .accdb in the dropdown list. 

Any ideas/suggestions? 

[Felipe_Ribeir0]

HI @paulgupta 

I used this connection a few times, i did it like this:

1)Install the access 32 bit driver (if you do not have them already):

https://www.microsoft.com/en-us/download/details.aspx?id=54920

2)Create the ODBC connection for the driver that you installed/access database file that you gonna use following the step 2 of the link above:

https://help.interfaceware.com/v6/connect-to-microsoft-access-odbc

3)Inside Alteryx, go to the input tool data connections, select data sources, 32-bit connections/ODBC and search for the ODBC connection that you created. After that, just select the table

4)As you can see above, the connection was made and it is ready to be used.

[Felipe_Ribeir0]

Hi @paulgupta 

It worked?

[paulgupta]

I am so sorry Felipe for not responding earlier....infact the need for the later version of Access file disappeared and I got busy in other things.  I will keep your recommendation in mind whenever such an opportunity arises.

Thanks a lot for your valuable suggestion.  Appreciate it!

Paul