Should I link or import?

T

Tricia

Does a linked table edit in both Excel and Access automatically? I will like
to work in Excel and the information show in Access without me manually doing
it. i am working with Windows XP I think.
 
R

Ron Hinds

Tricia said:
Does a linked table edit in both Excel and Access automatically? I will
like
to work in Excel and the information show in Access without me manually
doing
it. i am working with Windows XP I think.
Click to expand...

A linked table shares data. So changes to the data would be reflected in any
application linked to it. Importing would create a copy of the data as it
existed at the time of import. So changes to an imported table would not be
reflected elsewhere.
 
D

Douglas J. Steele

Ron Hinds said:
A linked table shares data. So changes to the data would be reflected in
any application linked to it. Importing would create a copy of the data as
it existed at the time of import. So changes to an imported table would
not be reflected elsewhere.
Click to expand...

That having been said, be aware that it's no longer possible to update a
linked spreadsheet from Acceses. However, any changes made to the
spreadsheet would reflect in Access.
 
Top