336Re: Realy need help
- Mar 1, 2004Thanks everyone, I'll play around and hopefully I'll be able to
convert without too mich trouble.
--- In Otter-Project@yahoogroups.com, "otrwash" <stewwright@w...>
> "toebig" <toebig@y...> wrote:spreadsheet
> > I've been playing around with Otter and trying to
> > figure out if there is an easy way to convert
> > my excel files into otter. All my records
> > are now in excel. I don't want to have to type
> > them all in again or even have to go into
> > otter and check each individule series with the
> > shows.
> It will probably not be a very straight forward process, especially
> if you have not done file conversion before. Excel is a
> and Otter is a database program. They store data, especiallydates,
> First and MOST IMPORTANT, SAVE A COPY of your Excel spreadsheet and
> work with the copy and not the original!
> You will need to export (Save As) your Excel spreadsheet into a
> file format that Otter will accept. This may require additionalHelp
> editing of the text file in a text processor such as NotePad or
> WordPad before importing the file into Otter.
> Before you start with the export, I recommend reading the Excel
> on "File format converters supplied with Microsoft Excel" and "How15.0
> Microsoft Excel stores dates and times."
> Next read the pertinent sections of THE UNOFFICIAL GUIDE TO OTTER.
> The format that Otter accepts is partially explained in section
> CREATING A NEW SERIES LOG AS A TEXT FILE of the THE UNOFFICIALGUIDE
> TO OTTER. Only certain fields are mentioned.because
> The fields in your Excel spreadsheet will have to be formatted
> exactly as Otter requires. If they aren't, you will have reformat
> your spreadsheet to comply with Otter's requirements. This may
> require reordering your spreadsheet fields (columns). You will
> probably have problems with the formatting of the date field
> Otter uses a date different format YY/MM/DD than Excel MM/DD/YY orin
> MM/DD/YYYY. This may require additional editing of the text file
> a text processor such as NotePad or WordPad before importing thefile
> into Otter.want
> If you have additional fields in your Excel spreadsheet, you may
> to export a log from Otter to see how it is formatted. Take a lookGUIDE
> at 19.0 HOW TO EXPORT A TEXT FILE FROM OTTER in THE UNOFFICIAL
> TO OTTER.
- << Previous post in topic Next post in topic >>