cyamamot@kilroy.jpl.nasa.gov (Cliff Yamamoto) (10/19/90)
Greetings, I'm sure a program like this must exists since it would seem to be useful for so many applications. I'd like to find a way to import or link database entries with entries in a spreadsheet (Lotus/Excel/whatever doesn't matter). What I'm looking for a way of searching for a item in a database (w/ some predicate), then once the entry or entries have been found, bring it's values into the spreadsheet. *THEN* if I change a value in the spreadsheet which affects the values for one of my spreadsheet entries, it's new updated value is reflected in the database respectively. If this isn't possible, it would be nice to at least have some sort of programmable macro that performed a database operation (query/sort/etc.) whenever a particular spreadsheet operation was performed. Is this too far fetched? I'd prefer something on the IBM/PC platform but I guess Macs would be ok. This doesn't have a be a full fledge product. It could be some add-on program to an existing database and/or spreadsheet program. Any pointers would be appreciated! I'll summarize if there is sufficient interest. Cliff Yamamoto
rlp@druwa.ATT.COM (PrehnRL) (10/19/90)
In article <1990Oct19.032936.6557@elroy.jpl.nasa.gov>, cyamamot@kilroy.jpl.nasa.gov (Cliff Yamamoto) writes: > I'd like to find a way to import or link database entries with entries > in a spreadsheet (Lotus/Excel/whatever doesn't matter). What I'm looking > for a way of searching for a item in a database (w/ some predicate), then > once the entry or entries have been found, bring it's values into the > spreadsheet. > > *THEN* if I change a value in the spreadsheet which affects the values > for one of my spreadsheet entries, it's new updated value is reflected > in the database respectively. > > If this isn't possible, it would be nice to at least have some sort of > programmable macro that performed a database operation (query/sort/etc.) > whenever a particular spreadsheet operation was performed. > > Cliff Yamamoto I don't have the documentation here & don't use spreadsheets but here is my $.02 worth. I belive you can grab data from the integrated database into a spreadsheet. I vaguely remember seeing macro commands for that while browsing thru the manual. It has a built in spreadsheet compatable with MS Excel & MS Multiplan & Lotus 1-2-3 1A & 2.x spreadsheets. It also has a built-in word-processor with spell checker & thesaurus, and electronic communications. The database allows you to create & store custom forms & reports. Bob Prehn
jkenyon@us.cc.umich.edu (Jim Kenyon) (10/19/90)
In article <1990Oct19.032936.6557@elroy.jpl.nasa.gov> cyamamot@kilroy.jpl.nasa.gov (Cliff Yamamoto) writes: > ---- deleted stuff ---- > >I'd like to find a way to import or link database entries with entries >in a spreadsheet (Lotus/Excel/whatever doesn't matter). What I'm looking >for a way of searching for a item in a database (w/ some predicate), then >once the entry or entries have been found, bring it's values into the >spreadsheet. > >*THEN* if I change a value in the spreadsheet which affects the values >for one of my spreadsheet entries, it's new updated value is reflected >in the database respectively. > ---- more deleted ---- > >Is this too far fetched? I'd prefer something on the IBM/PC platform but >I guess Macs would be ok. This doesn't have a be a full fledge product. >It could be some add-on program to an existing database and/or spreadsheet >program. > > >Cliff Yamamoto Try Lotus Symphony -- I thought it was a spreadsheet cum database. Also, Ashton Tate Framework might be of interest.... -- Jim Kenyon -- jkenyon@css.itd.umich.edu University of Michigan, 401 Washtenaw Ave Division of Kinsesiology, Motor Behavior Lab Ann Arbor, MI 48109 -- (313) 763-0498
woody@eos.arc.nasa.gov (Wayne Wood) (10/20/90)
In article <1990Oct19.163313.15580@terminator.cc.umich.edu$ jkenyon@us.cc.umich.edu (Jim Kenyon) writes: $In article <1990Oct19.032936.6557@elroy.jpl.nasa.gov$ cyamamot@kilroy.jpl.nasa.gov (Cliff Yamamoto) writes: $$for a way of searching for a item in a database (w/ some predicate), then $$once the entry or entries have been found, bring it's values into the $$spreadsheet. $$ $$*THEN* if I change a value in the spreadsheet which affects the values $$for one of my spreadsheet entries, it's new updated value is reflected $$in the database respectively. $$Cliff Yamamoto $ $Try Lotus Symphony -- I thought it was a spreadsheet cum database. $Also, Ashton Tate Framework might be of interest.... or if you want to do it on the cheap, try MicroSoft WORKS... also, LOTUS-123 and Quattro (BORLAND) both have limited database capabilities built in... maybe you could..... /*** woody **************************************************************** *** ...tongue tied and twisted, just an earth bound misfit, I... *** *** -- David Gilmour, Pink Floyd *** ****** woody@eos.arc.nasa.gov *** my opinions, like my mind, are my own ******/
amichiel@rodan.acs.syr.edu (Allen J Michielsen) (10/20/90)
>In article <1990Oct19.032936.6557@elroy.jpl.nasa.gov> cyamamot@kilroy.jpl.nasa.gov (Cliff Yamamoto) writes: >---- deleted stuff ---- >>I'd like to find a way to import or link database entries with entries >>in a spreadsheet... searching for a item in a database, then >>once the entry or entries have been found, bring it's values...spreadsheet. >> >>*THEN* if I change a value in the spreadsheet which affects the values >>for one of my spreadsheet entries, it's new updated value is reflected >>in the database respectively. >> Most of this sounds just like the features added in lotus 123 version 3 and above. The search part will probably require work writing some (better) macros, but linking the spreadsheets is what it's all about isn't it ? The alternate case I guess may be a recommendation///////////// no make that a suggestion to look at dbase. I neither confirm nor deny, but see that it's popular in the marketplace. al -- Al. Michielsen, Mechanical & Aerospace Engineering, Syracuse University InterNet: amichiel@rodan.acs.syr.edu amichiel@sunrise.acs.syr.edu Bitnet: AMICHIEL@SUNRISE