Sharing Data between Base and a spreadsheet
Posted: Tue Aug 06, 2019 8:12 pm
For many years (30 to be exact) I had an ancient 640k computer that utilized Ashton-Tate DB3. I had with the help of a dummies book written a small program that kept track of my financial affairs and updated it monthly with a simple program that calculated the monthly gain or loss of income in my stock portfolio, IRA's and CD's. It basically worked by copying the files to a temp file updating them and returning them in their updated status to the DB. It was not vey sophisticated but served my needs and as the computer aged it very primitiveness kept it safe from hacking and data breaching.
Well long story short my computer died and after the tech finished laughing when I took it to be repaired, I started trying to figure out how I was going to replace my little financial buddy. I started using excel and in spite of my age taught myself enough to create a spreadsheet that served my needs.
I am however not happy with the way the data looks so I thought why not try Open office and see if I could use the data base function and link it to my excel spreadsheets so I get the nice reports to which I had become accustomed. This has exceeded my capabilities and viewing the many solutions offered on line- none seemed to work either I am dumb as a box of rocks or the methods offered up were for older versions of Open Office.
So after that very long preamble my question is Does Open Office v4.16 (DBase) have a method where a spreadsheet can be linked to a db file so information can be copied updated and returned! Thanks very much for reading this tome
Well long story short my computer died and after the tech finished laughing when I took it to be repaired, I started trying to figure out how I was going to replace my little financial buddy. I started using excel and in spite of my age taught myself enough to create a spreadsheet that served my needs.
I am however not happy with the way the data looks so I thought why not try Open office and see if I could use the data base function and link it to my excel spreadsheets so I get the nice reports to which I had become accustomed. This has exceeded my capabilities and viewing the many solutions offered on line- none seemed to work either I am dumb as a box of rocks or the methods offered up were for older versions of Open Office.
So after that very long preamble my question is Does Open Office v4.16 (DBase) have a method where a spreadsheet can be linked to a db file so information can be copied updated and returned! Thanks very much for reading this tome