access and excel linked file question

K

KP

I have an excel file linked to Access. The excel file is updated frequently
and maintained at another office. I have added an extra column to
distinguish obsolete information but am unsure how to incorporate the updates
without corrupting the existing file.

The issues being:

1. Don't want to lose column I've created

2. Need to update existing information

3. How will new rows of information affect the column I added?

*I am unable to have the other person add my information to their file.
Any suggestions?
Thanks!!
 
Top