retrieve data from MS Access

[inungh]

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,

 

[Joel]

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]

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








- Show quoted text -

Thanks millions for the information,