link to Access DB
Getting data ourt of access is easy. Data - Get External Data - New
database query. Writing data back to access automatically is a whole
different stroy. You need to be familiar with VBA and specifically with ADO
DB recordsets. If you are not comfortable with those things then I am affraid
you are stuck (To the best of my knowledge).
HTH
"MaureenKLM" wrote:
Excel '02 or higher with Access '02 or higher
From within Excel, Can I link to info in an Access DB and update the Access
data from within Excel?
I see that I can LINK to Excel from within Access, but I'm not seeing the
option to link to Access from within Excel.
Thanks in advance for your help!
|