string formula

[Dim]

Hi,
need some help/idea...
I have data table in Excel(about 30 columns) and it's getting too big
(over 65K) so I need to move it to DB (MS Access is the choice)
one of the columns (for example column1 in DataTable has a string (for
example AAA, ABC or BCA, etc) and i also have lookup table in excel
with formulas which contains a business rule for one of the columns
(column35) on how to calculate: for example for AAA the calculation
would be (Column 3 + Column 4) * Column8 / 2, for ABC it might be
completely different formula...currently there are about 300
formulas...
In excel i created a funciton which picks up a text formula in lookup
table brings it into specific cell in the column, converts it into
excel formula and calc a result...
is it any way i can do the same in access: create lookup table with
formulas and then apply them in datatable for calculations? if not
what's my best choice/way of approaching it...
thanks in advance
Dim

[MacDermott]

You can do something analagous in Access using the Eval() function - check
it out in the Help file.

However, with that many records, I'd expect performance to be poor.
Once you get your initial migration to Access done, you might consider
rewriting that into a function call.

Also, you'll probably find that it's easier to keep track of things in
Access if you'll give your fields meaningful names instead of just column
numbers.

HTH
- Turtle

"Dim" <di*****@yahoo.com> wrote in message
news:f1**************************@posting.google.c om...

Hi,
need some help/idea...
I have data table in Excel(about 30 columns) and it's getting too big
(over 65K) so I need to move it to DB (MS Access is the choice)
one of the columns (for example column1 in DataTable has a string (for
example AAA, ABC or BCA, etc) and i also have lookup table in excel
with formulas which contains a business rule for one of the columns
(column35) on how to calculate: for example for AAA the calculation
would be (Column 3 + Column 4) * Column8 / 2, for ABC it might be
completely different formula...currently there are about 300
formulas...
In excel i created a funciton which picks up a text formula in lookup
table brings it into specific cell in the column, converts it into
excel formula and calc a result...
is it any way i can do the same in access: create lookup table with
formulas and then apply them in datatable for calculations? if not
what's my best choice/way of approaching it...
thanks in advance
Dim