another Excell question

RoniMan · 08-01-2004, 09:34 AM

i tried reading the help on this, but didn't quite understand it.

is there a way to make a "database" in excel?

basically, i want to list of equations like x+1, 2x-1, ..etc. then i would like to randomly draw equations from that database.

TIA

DarkFury · 08-01-2004, 10:05 AM

Yes... Excel does have a "minor" database function... however it will never be as powerful as a true "Access" database (as a simple database) or FoxBase database.

Basically, you need to set up an array of values and then have each variable refer to the correct value for your equation.

RoniMan · 08-01-2004, 10:52 PM

Quote:

Originally Posted by DarkFury

Yes... Excel does have a "minor" database function... however it will never be as powerful as a true "Access" database (as a simple database) or FoxBase database.

Basically, you need to set up an array of values and then have each variable refer to the correct value for your equation.

...........................
um....can you be a bit more specific?

DarkFury · 08-01-2004, 10:59 PM

Sorry man... it's been SO long since I have even done anything like that (especially since I use Access more often for database functions). I just can't give you an example.

Best I can recommend is use the Excel help files to help you figure it out.

Cheesypuff · 08-02-2004, 01:45 AM

as far as I can remember for using excel as a database,

you need to skip the first column and row (actually, i don't know if you need to skip the first column, but hey...it can't hurt) for excel to reconize the data as a database. hope that helps...plus, I don't even know if that is correct! Sorry

it's been so long since I've used excel as a database...like DF said...access is what I've been using!

08-01-2004, 09:34 AM	#1
RoniMan Admiral Join Date: Apr 2000 Location: Temple City, CA Posts: 5,140	another Excel question i tried reading the help on this, but didn't quite understand it. is there a way to make a "database" in excel? basically, i want to list of equations like x+1, 2x-1, ..etc. then i would like to randomly draw equations from that database. TIA Last edited by RoniMan : 08-01-2004 at 10:04 AM.

08-01-2004, 10:05 AM	#2
DarkFury Secretary of the Navy Join Date: Feb 2001 Location: Chillin' N Da 'Hood Posts: 34,997	Yes... Excel does have a "minor" database function... however it will never be as powerful as a true "Access" database (as a simple database) or FoxBase database. Basically, you need to set up an array of values and then have each variable refer to the correct value for your equation. __________________ DarkFury's Pimptopia - Don't Hate the Playa, Hate the Game! Home of the Original OG Pimp (accept NO imitations)

08-02-2004, 01:45 AM	#5
Cheesypuff Vice Admiral Join Date: Dec 2000 Location: Cali, but missing Hong Kong and Texas Posts: 4,782	as far as I can remember for using excel as a database, you need to skip the first column and row (actually, i don't know if you need to skip the first column, but hey...it can't hurt) for excel to reconize the data as a database. hope that helps...plus, I don't even know if that is correct! Sorry it's been so long since I've used excel as a database...like DF said...access is what I've been using! __________________ Life is like toilet paper, long and useful! The stars at night, are big and bright clap 4x deep in the heart of TEXAS!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

08-01-2004, 10:59 PM	#4
DarkFury Secretary of the Navy Join Date: Feb 2001 Location: Chillin' N Da 'Hood Posts: 34,997	Sorry man... it's been SO long since I have even done anything like that (especially since I use Access more often for database functions). I just can't give you an example. Best I can recommend is use the Excel help files to help you figure it out.

User Name
Password
Remember Me?