Excel to Access with Excel formulas

[Guest]

Is it possible to import an Excel database into the
Access table together with the formulas, eg, c2=b2+b1??

Thanks.

 

[John Nurick]

Hi,

You can't do this with Access's ordinary import routine. It is possible
to write VBA code that reads the formulas in each cell in the worksheet
and creates corresponding records in an Access table - but all this
would give you is the text of the formulas, not the calculating ability
of Excel.