Access database info to Excel spreadsheet

  • Thread starter Thread starter Kathi
  • Start date Start date
K

Kathi

Okay, I imported a table from my company master database
file from Access, I imported it into my excel wrksheet on
my computer however, when someone updates the info on
Access, I would like it automatically updated in my
spreadsheet. Is this not possible? What's the solution?
When I go to to my new Excel workbook and click EDIT,
then try to go to LINKS "links" is in gray color and not
available to me. Any suggestions?
 
How did you import it? From Access, you can link to an Excel spreadsheet
(File>Get External Data>Link Tables...) If you use that method, changes
made in Excel will be displayed automatically in Access, and vice versa.
 
Back
Top