D
Derek Salkeld
we are moving a large mathematical model from Excel to Access.
Each Access record contains textual details of a part of the model, and in
an OLE field, a chunk of spreadsheet of variable size containing the maths.
There are a >1000 such records.
We want to select sub-sets of the records, say 100, and have Access
re-export the selected, discrete, spreadsheet chunks back out into a workbook
for calculations and analysis.
The chunks contain both data and formulae, but so far, all we have been able
to export are data.
Can anyone tell me how to export the formulae?
Apologies if this is a naive question, but it is our first venture in Access
and your advice will be much appreciated. Thank you.
Each Access record contains textual details of a part of the model, and in
an OLE field, a chunk of spreadsheet of variable size containing the maths.
There are a >1000 such records.
We want to select sub-sets of the records, say 100, and have Access
re-export the selected, discrete, spreadsheet chunks back out into a workbook
for calculations and analysis.
The chunks contain both data and formulae, but so far, all we have been able
to export are data.
Can anyone tell me how to export the formulae?
Apologies if this is a naive question, but it is our first venture in Access
and your advice will be much appreciated. Thank you.