By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,958 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

string formula

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.