> > From: Rod Engelsman <[EMAIL PROTECTED]> > Date: 2005/02/12 Sat PM 11:26:48 GMT > To: [email protected] > Subject: [users] Re: Data Base Help > > [EMAIL PROTECTED] wrote: > > > > Once you've finished cleaning the data, and you're satisfied that you've got a > > good data set, delete the first three columns and save the sheet. Then save it > > again as a DBF. Now you can use it as a data source, and use Open Office as a > > front end to enter or correct data. > > You were good up to that point. Deleting the first three columns will > get you a bunch of error messages and/or blank cells in the remaining > columns. I think what you want to do is select the result columns, copy > to clipboard, and then do a "Paste Special" back in as "Value" IIRC. > > Rod Thanks, Rod. You're right. I forgot about that.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
