Access - Excel

[Guest]

I have an Excel file and an Access file.

I -
.. open Excel
.. select a graph
.. select Copy
.. move to Access
.. create a new form
.. Paste Special
.. close and save the form.

On another form I have code which -
.. updates in the Excel file a field on which the chart depends
.. opens the form with the chart.

The chart on the form doesn't update.

Is this to do with the "Linked Excel Data No Longer Updatable" article in
the April 2006 issue of Advisor?

What other options are there?

Cheers ...

 

[Stefan Hoffmann]

hi Frank,

.. open Excel
.. select a graph
.. select Copy
.. move to Access
.. create a new form
.. Paste Special
.. close and save the form.
The chart on the form doesn't update.

This sounds to be an embedded OleObject.

Is this to do with the "Linked Excel Data No Longer Updatable" article in
the April 2006 issue of Advisor?

No, as the "updatable" means, that you cannot change data in an Excel
sheet from Access when it is a linked table.

Link the sheet and build the graph new on an Access form. Then
(re-)opening the form will use the updated data from Excel.


mfG
--> stefan <--

 

[Guest]

I don't understand ...

hi Frank,

This sounds to be an embedded OleObject.

No, as the "updatable" means, that you cannot change data in an Excel
sheet from Access when it is a linked table.

Link the sheet and build the graph new on an Access form. Then
(re-)opening the form will use the updated data from Excel.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi Frank,

I don't understand ...

Look under Files/External Data (or so) and use the Link Table point.
Select your Excel sheet as datasource.


mfG
--> stefan <--

 

[Arvin Meyer [MVP]]

You can still link the Excel spreadsheet in Access. It will no longer update
the Excel data. If you are having a problem, try refreshing the links before
opening the form or report which contains the data. Just use the
TransferSpreadsheet method:

' First delete the Excel linked table
DoCmd.DeleteObject acTable, "Excel Table Name"
' Then reimport it
DoCmd.TransferSpreadsheet acImport, spreadsheettype, tablename, filename[,
hasfieldnames][, range]