View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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