Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
link to Access DB
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
link to Access DB
"MaureenKLM" wrote in message ... 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! If you click F1 in Excel and enter the magic word "database", you should get a help item that explains how to export data from Excel into Access. At least if you have Excel 2003. I have the Swedish version but I don't think the online help is different from what you have. /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Excel To Access | Excel Discussion (Misc queries) | |||
Link to access database | Excel Discussion (Misc queries) | |||
Link Excel to Access | Excel Discussion (Misc queries) | |||
ACCESS/EXCEL LINK | Excel Discussion (Misc queries) | |||
excel/access link | Excel Discussion (Misc queries) |