string formula - Microsoft Access / VBA

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...curre ntly 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

Subscribe Reply

2692

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.goo gle.com...

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...curre ntly 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

Similar topics

2016

How to write any string

by: Bob Murdoch | last post by:

I have a situation where I call a COM object from ASP that is supposed to create a file. On occasion, especially during development, the output of the COM function is an error string rather than the file name. I'd like to display this error string, regardless of it's contents. Right now, depending on the error string, I get an error message about missing a semicolon or some such. I've tried using Encode and Server.HTMLEncode with no...

ASP / Active Server Pages

3333

How to convert string to upper case using Field's Formula Property

by: Max | last post by:

Hi, I am trying to convert string entered in a field to uppercase using its formula property. I know it can be done using trigger but still I want to use formula property to achieve the same. Any help will be greatly appreciated. -Max

Microsoft SQL Server

26372

Converting string formula to mathematical formula

by: VM | last post by:

If I have a string variable with a formula: string sMyformula = "3.3*5.2*5"; How can I convert this to a mathematical formula that the compiler can calculate? For all purposes, the formula in the string will always be valid. Thanks

C# / C Sharp

5182

Converting String Value to a Formula for calculation?

by: SiewSa | last post by:

I have come to a situation that I need to use the result of a string variable as a formula for performing calculation. As an example below: Dim X As Integer Dim Y As Integer Dim Result As Integer

Visual Basic .NET

10720

Evaluating a mathematical string formula.

by: Wade | last post by:

Hi guys, I am building a string in code that is a mathematical formula, based on a lot of criteria specified by the user. Once the formula is complete, I want to evaluate it to get a result. For example: dim strFormula as String strFormula = "((2 + 2) * 3) / 4) - 5"

Visual Basic .NET

1118

displaying a date as a string in crystal reports

by: jonefer | last post by:

Basic Syntax: I have a formula that needs to return "N/A" or a date. So the formula returns string where I am stuck is what is the equivalent of (MS Access) Format(, "mm/dd/yyyy") because the string my formula returns always has the time in it too and I want only the "mm/dd/yyyy" portion of the date in my string.

.NET Framework

1804

problem with string&

by: sernamar | last post by:

Hi, I have the following base class class UnitOfMeasure { public: //... std::string& GetName() {return _uomName;}; //... protected:

C / C++

2063

Evaluate a formula given as string

by: Reshmi Jacob | last post by:

Hello..... In my program I have 3 variables, say a = 10 b = 20 c = 30 I have a variable as string

Visual Basic 4 / 5 / 6

1643

How do I get the answer of a string formula?

by: Alfredo73 | last post by:

Hi, In the user input of a textbox I would like that the user can input a formula to make it easier for him. So instead of inputing 400 I would like the user to have the possibility to input as 8*50. Is there a command for vb2008 to calculate the answer of this formula inputed by a string ? Thanks in advance.

Visual Basic .NET

10162

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

11566

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

11153

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7426

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

6112

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

6331

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4941

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

4533

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3541

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General