access tables linked to excel files won't update.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have updated the data in an excel worksheet. I have used the linked table
manager, as well as importing the data, but the new data does not show up in
the access tables. HELP!!
 
Do you mean that when you import data from the worksheet into a new
Access table, the table ends up containing not the values that are in
the worksheet, but values that used to be there?

If so,
1) Make certain that the worksheet has been recalculated and saved
before you try to import it.

2) Make certain that you're actually importing from the sheet you think
you're importing from.

3) If the cells that are not being correcetly imported contain formulas,
try copying the Excel data and then (still in Excel) use Edit|Paste
Special|Values. This replaces the formulas with their results and cuts
out one source of possible problems.
 
That is correct. I have saved the updated worksheet, but the data entered
recently is not showing up in access. I entered all April attendees to a
meeting, but nothing past March appears in the Access table.
 
Check to see if there is a range defined with the same name as the page.

Also, open the link in design view and check to see what exactly you are
linked to.

(david)
 
Are all the results in a single contiguous rectangular range in the
worksheet, with every row having exactly the same "fields", just like an
Access table, or are the April records separate from the March ones?
 
Back
Top