On Saturday 01 September 2007 09:07:43 pm Christian Einfeldt wrote: > Thanks everyone for your replies. Sorry for the lag in responding.. > > On 9/1/07, Joe Conner <[EMAIL PROTECTED]> wrote: > > It sounds to me as if it is past time that a database replaced that > > Excel spreadsheet.!! :-) > > Okay, but that is a systemic change that I am not going to be able to > implement in the next 72 hours, which is when the teacher needs the > solution. Or is it possible to make that change? The problem is that the > school has standardized on a spreadsheet. Getting the whole school to move > to a database would take some work. I am definitely open to suggestions. > Again, thanks for the suggestions!
First, have you tried saving this current spreadsheet as a text based, csv file? And then, importing the csv into OOo? Second, I don't think it would be hard to get the thing into a database. The hardest part is setting up the DB. You'll need some help with that other than me, as I'm no db expert. however, I think even I could set something up in a rather crude, get me started kinda way. Third, in Excel, break the spreadsheet out into multiple spreadsheets. I'm assuming here that there are no advanced formulas and/or macros? That may be the problem rather than the size of it. -- See Ya' Howard Coles Jr. John 3:16! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
