On Dec 9, 12:11*pm, Joel wrote:
I set up my connnections manually while record a macro in excel. *When you
choose the record set manually you can select which fields of data you want
to download. * Once you get the recorded macro you can modified the macro as
required.

1) Tools - Macro - Record New Macro
2) Data - Import External Data - New Database Query. *Select the file and
dable. *the choose the fields you want to download
3) Tools - Macro - Stop Recording



"inungh" wrote:
I would like to retrieve one field from MS Acess to fill my cell.

I used ADODBConnection and *ADODBRecordset to retrieve dataset.

I just wanted to know are there any easy way to get one field data
like DLookup in the MS Access.

Your help is great appreciated,- Hide quoted text -

- Show quoted text -

Thanks millions for the information,