Make changes to Linked Table

  • Thread starter Thread starter dolphinv4
  • Start date Start date
D

dolphinv4

Hi,

I have an access table that is a linked excel table. I
want to make changes (ie, add columns) to this linked
table in access but I can't. I can't make changes in the
excel table in excel because it doesn't belong to me.

Is there any way I can add/amend the table in access? I
tried creating a new table/query but it seems like a drop
down column is created instead. but what i want is to have
a new table that is linked to the excel linked table with
some of the columns linked to the excel linked table.

How do i do it?

Thanks.
Val
 
In Addition,

I'd like the new table that is linked to the excel table
to refresh itself whenever the excel table adds new rows.

Rgds,
Val
 
Back
Top