Converting Excel spreadsheet with formulae to Access database
We currently use an Excel spreadsheet at work which includes a number of
VLOOKUP and SUM formulae. I'd like to create a Microsoft Access database from
this spreadsheet - is there a way of retaining or replicating these formulae
in Access? (I do not want to simply link the spreadsheet to Access as this
won't speed up access to the data)
Thanks,
Andy
--
Andreas L.
|