Excel and Access

  • Thread starter Thread starter scubatony
  • Start date Start date
S

scubatony

Can anybody point me in the right direction to make an Excel spreadsheet and
an Access database work together

More details if needed
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Access - importing an excel spreadsheet 0
Opening excel 2010 spreadsheet from Access 4
Excel Spreadsheets keep moving 0
How do I set up an Excel file to be imported into Access 1
Excel as data entry form? 5
mapping from excel 2
Access will not accept a date of less than 1900 from Excel. Why 2

Back
Top