Link Access table to Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to link these so that they can be edited in either programme.
Whichever way, the link box is greyed out.
 
You can make a linked table in Access. It's File - Get External Data -
Link. The data lives in the Excel workbook, I think (I don't think Access
keeps a copy of it). But you can change data in either Excel or Access.
 
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

Breaking links between workbooks in Excel 2000 1
Break internal links 3
Checking/amending the external source link to an Access table 1
Link to the FIRST worksheet 3
Need Help! Adjusting Excel Worksheet to PPT 2
Breaking external Links 1
Link in worksheet 3
Cannot delete a worksheet in Excel (Office 2007), but the option i 1

Back
Top