Linked excel spreadsheet and then split

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Hi Mates

I have a linked access table created from an excel
spreadsheet. Then I used Table Analyze feature in access
to split this and the split created 3 seperate tables.

When the excel spreadsheet is changed the linked table
gets updated but split tables remains unchanged. Is there
a way these split tables to get updated automatically.

Thanks mates in advance for your help.

Sarah W
..
 
Answered in .conversion.

Hi Mates

I have a linked access table created from an excel
spreadsheet. Then I used Table Analyze feature in access
to split this and the split created 3 seperate tables.

When the excel spreadsheet is changed the linked table
gets updated but split tables remains unchanged. Is there
a way these split tables to get updated automatically.

Thanks mates in advance for your help.

Sarah W
.
Click to expand...
 
Back
Top