| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
