Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel and Access
Can anybody point me in the right direction to make an Excel spreadsheet and
an Access database work together More details if needed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel and Access
Hi,
Depends on whether you are working with Excel data in Access or Access data in Excel. In Excel you can grab Access data via 1. The Data, Pivot Table & PiovtChart command..., 2. The Data, Import External Data In Access you can link to or copy data from Excel by choosing File, Get External Data.... In Access you can send data to Excel by choosing Tools, Office Links, Analyze it with Microsoft Office Excel. You can also connect via VBA. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "scubatony" wrote: Can anybody point me in the right direction to make an Excel spreadsheet and an Access database work together More details if needed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Macro to check data from excel list against access query and return value back to excel | Excel Worksheet Functions | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) |