Re: data import from Lotus or Excel to Oracle 8i

Lesley,

A couple of options:

1. Export the data to a flat(ascii) file and use SQL Loader to import the data to Oracle. A little trick when saving an Excel spreadsheet as a flat file for importing to a DB - define the width of each column to an integer value(larger than actual data width) and then save the file as a space delimited(.prn) file. This causes the text file columns to be sized the same as in the spreadsheet.
2. Use VBA ODBC procedure to insert data directly into the Oracle DB. Wish I had my VBA reference with me today so I could give you some sample code.

Hope this helps.

DawgByte

Lesley Boughner wrote:

> Hello everyone!
> Please excuse my lack of knowledge in Oracle 8i, I've just been put on this
> project 2 days ago and I must admit I'm a little overwhelmed. We're in a
> crunch and I don't have a lot of time to take my time and research and learn
> oracle the way I'd like to.
>
> I'm looking for the best way to import data from Lotus or Excel (doesn't
> matter whichever is easier, the data is currently in DataEase) into Oracle
> 8i. Do I have to write batch files or a VB procedure? (I'm a vb programmer
> so that's what I know) Could anyone point me in the right direction - to
> articles or a book in particular that would help me with.
>
> Thank you in advance for any suggestions.
> Lesley Boughner

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Feb 01 2000 - 11:50:11 CST