Getting result from EXTERNAL MS Access DB

[Stoffel24]

Hi all

I have a requirement to query a table in an external Access database. I have created a connection to this external database as shown below (Data_source is the external database path):

Set dbDoc = DBEngine.Workspaces(0).OpenDatabase(Data_Source)

Now I need to query a table called Field_master in Data_source. I have 2 questions:

1) Should I do this with a sql command or use an openrecordset or what?

2) Once I have queried this database, if I do it with a sql command and I return the 2 fields I need (call them field1 and field2) how do I extract the appropriate one?

Thanks in advance...