Link Excel - Cannot Edit

  • Thread starter Thread starter Ste
  • Start date Start date
S

Ste

i wondered if anyone could help?

I have an Access database in which I use 4 linked tables
(which are linked to Excel spreadsheets). I have a query
pointing to two of the spreadsheets and a normal table.
The problem I have is that I cannot edit or add to the
data stored in the access table. Does anyone know the
problem?

Ste
..
 
Is the link or is it the query? If you're using a nonupdatable query, you
cannot edit the records.

You'll need to provide us with more details about the files, the queries,
etc.
 
Ste: When Access links to data in an Excel spreadsheet,
it generates the Access table using only values. For
example, if you had an Excel spread sheet with the
numbers 1-9 in a column, and a sum function at the
bottom, it would show 45. The linked table in Access
would show the a field with rows 1-9 and a 10th row of
45. You may change any of the numbers 1-9 however it will
not be reflected in the sum unless the Excel is running
that sheet at the same time. You can never change the row
containing the sum function at any time as this would
change the function of the Excel sheet. In other words,
you can use Access to modify Excel data, but not any
cells which contain a function.

Hope this helps, Ray
 
Back
Top