Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
retrieve data from MS Access
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
retrieve data from MS Access
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
retrieve data from MS Access
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retrieve data from Access Database | Excel Programming | |||
How to get Excel to retrieve aggregate data from Access | Excel Programming | |||
Use ADO to retrieve data from Access Parameter Query | Excel Programming | |||
Access and retrieve data from network workbook | Excel Programming | |||
Access and retrieve data from network workbook | Excel Programming |