Access database info to Excel spreadsheet

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?
 
D

Debra Dalgleish

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.
 
Top