Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: excel to oracle

Re: excel to oracle

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 06 Oct 2007 18:58:45 +0100
Message-ID: <FO6dnXkIfO1SV5raRVnytwA@pipex.net>


Tim B wrote:

> Well, today I found out that for every record I import from my spreadsheet I
> will need to add a record to an additional table, and I'll have to deal with
> a couple of sequences. What I'm likely going to do is import the spreadsheet
> into Access and use some VBA to read the records, create the needed insert
> statements, and save them to a text file. I'll keep your solution in mind
> for when I have a more straightforward import to do. Thanks.

If you are going to write vba, why not just do it from excel and avoid the access intermediate step altogether.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Sat Oct 06 2007 - 12:58:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US