Linked excel spreadsheet and then split

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

John Nurick

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Linking data in MS Word into Excel 5
Embed the same Excel multiple times 0
Integrating information from Word to Excel (not mail merge) 1
tables created by Linking an Excel File 1
Excel does not accept text format! 0
Importing Data from Spreadsheet - Efficient Design 1
Link Excel to word 2

Top