Executing Excel-type formulas written within an Access table 1

[Techno1X]

Situation:

I have a large list of various MS Excel formulas which are written as "String" format in an Access table. For example, the SUM function (SUM(field1,field2)), although the list of formulas is very large and they already include the data fields which need to be calculated on (see above: field1, field2). I'm using a macro to execute these formulas one by one, but Access does not recognize them(?) Is there a way to export the data/formulas to do this in Excel? Keep in mind I would like the results to be finalized in Access. I'm using VBA/Access but have Excel as well.

Thank you..

 

[maxhugen]

Check out the Eval() function in Access Help.

Bear in mind though, that Access and Excel functions can differ, whilst some are available in one but not the other. You may be able to resolve these anyway, if you set a Reference to Excel in Access:

Open the VBA Editor, go to Tools > References, and check "Microsoft Excel x.x Object Library".

Max Hugen
Australia