Loading ...
Sorry, an error occurred while loading the content.

336Re: Realy need help

Expand Messages
  • toebig
    Mar 1, 2004
    • 0 Attachment
      Thanks everyone, I'll play around and hopefully I'll be able to
      convert without too mich trouble.

      Tom (toebig)


      --- In Otter-Project@yahoogroups.com, "otrwash" <stewwright@w...>
      wrote:
      > "toebig" <toebig@y...> wrote:
      > > 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
      spreadsheet
      > and Otter is a database program. They store data, especially
      dates,
      > differently.
      >
      > 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
      text
      > file format that Otter will accept. This may require additional
      > 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
      Help
      > on "File format converters supplied with Microsoft Excel" and "How
      > 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
      15.0
      > CREATING A NEW SERIES LOG AS A TEXT FILE of the THE UNOFFICIAL
      GUIDE
      > TO OTTER. Only certain fields are mentioned.
      >
      > 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
      because
      > Otter uses a date different format YY/MM/DD than Excel MM/DD/YY or
      > MM/DD/YYYY. This may require additional editing of the text file
      in
      > a text processor such as NotePad or WordPad before importing the
      file
      > into Otter.
      >
      > If you have additional fields in your Excel spreadsheet, you may
      want
      > to export a log from Otter to see how it is formatted. Take a look
      > at 19.0 HOW TO EXPORT A TEXT FILE FROM OTTER in THE UNOFFICIAL
      GUIDE
      > TO OTTER.
      >
      >
      > Stewart
    • Show all 7 messages in this topic