home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #1 / NN_1993_1.iso / spool / comp / database / oracle / 2702 < prev    next >
Encoding:
Text File  |  1993-01-07  |  1.2 KB  |  30 lines
  1. Newsgroups: comp.databases.oracle
  2. Path: sparky!uunet!munnari.oz.au!newsroom.utas.edu.au!ml.csiro.au!solaris!jstander
  3. From: jstander@ml.csiro.au (Jeff Stander)
  4. Subject: Re: Importing files from LOTUS
  5. Message-ID: <1993Jan7.050920.3050@ml.csiro.au>
  6. Sender: news@ml.csiro.au
  7. Reply-To: jstander@ml.csiro.au
  8. Organization: CSIRO Marine Laboratories
  9. References: <31379@nntp_server.ems.cdc.com>
  10. Date: Thu, 7 Jan 1993 05:09:20 GMT
  11. Lines: 17
  12.  
  13.  
  14. ---
  15.  
  16. I can't remember if LOTUS can export in a dBase format, but I routinely
  17. need to import data into our Oracle system running on a Sun and I use
  18. a home-grown program that reads dBase or Foxpro files directly, rewrites
  19. the data and data structure as a text file, and then creates the .sql and
  20. .ctl files for table creation and loading.  
  21.  
  22. ___________________________________________________________________________
  23.  
  24. Jeff.Stander@ml.csiro.au         _--_|\        Database Analyst
  25. CISRO Division Of Fisheries     /      \       Pelagic Fisheries Resources
  26. GPO Box 1538, Hobart            \_.--._/       Tel: +61-02-206-206
  27. Tasmania 7001, Australia              v        Fax: +61-02-240-530
  28. ___________________________________________________________________________
  29.  
  30.