Hi Chris,
There isn't even a difficult method<g>: you have to start from scratch.
Generally it's quite simple to create an expression (calculated field)
in an Access query that does the same job as an Excel formula, but
(a) some Excel worksheet functions don't have direct equivalents in SQL
or VBA, so it's more often necessary to write custom VBA functions.
(b) in a formula it's dead easy to refer to cells in other rows or
worksheets, but in a query it's not so easy.
(c) there are some things you can do in formulas that can't be done at
all in Access queries; one ends up using recordset operations in VBA.
Is there an easy method to import an Excel formula to an
Access db? I'm guessing that it would have to be converted
to be used in an Access query. Thanks
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
