Hi there,,

I firts of all, I'm new in this forum where I have found a lot of information very useful for me, since I have not used access too much.

I would like to know if somebody have done Queries in Access 2007 getting information from external data source using ODBC .. ?? especially getting data from AS/400 (BD2)..

I have done this in excel ,, but I would like to do it with out code in Access... if possible

I appreciate your comments..

MR :)

Hi there,,

I firts of all, I'm new in this forum where I have found a lot of information very useful for me, since I have not used access too much.

I would like to know if somebody have done Queries in Access 2007 getting information from external data source using ODBC .. ?? especially getting data from AS/400 (BD2)..

I have done this in excel ,, but I would like to do it with out code in Access... if possible

I appreciate your comments..

MR :)

AFAIK, you do not need any VBA code to create a query on a ODBC linked table.

Have you tried:

1) Install the ODBC driver
2) Create a DSN
3) Create a linked table(s) via the DSN/ODBC
4) Create a query on the linked table(s).