Excel to Access with Excel formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks.
 
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.
 
Back
Top