| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get data from Access file
HI All,
Is it possible to populate a cell from a cell (if that’s what it’s called) in an Access file? The access file is called qcpProg.mdb in a directory level one above the excel file. The data is in the tProduct table, UnitCost field (currency), with the Product Code field (text) that is equal to Joseph4. It would save me a lot of manual updates if I could do this. Thanks! Michele |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get data from Access file
Hi Michele,
In excel 2000, I use Data Get External Data New Database query. Would that work in your case? Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import excel file to access but only new data | Excel Programming | |||
| Refresh Data if Access File has Password | Excel Programming | |||
| Access data on spreadsheet without accessing the file?... | Excel Discussion (Misc queries) | |||
| Write data to access file through EXCEL | Excel Programming | |||
| excel to manage access data file | Excel Programming | |||
Hybrid Mode
