Re: loading Data from a flat file

From: Anurag <anurag_at_synergy-infotech.com>
Date: Fri, 26 Nov 1999 06:11:08 -0800
Message-ID: <0a0133f8.62bf47d5@usw-ex0102-014.remarq.com>

Hi,
But still i think one has to define the table structure in MS-ACCESS. I already have a table structure defined in oracle and i want to use that only.

Thanks
Anurag

In article <383E77BF.A55BDEB9_at_synes.com>, Haghkhah Majid <majid.haghkhah_at_synes.com> wrote:
> --------------C4FF021DE384BC2BD0594E40
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> Hello,
> One possible way.
> If your file is not big, just read the file to Access database.
> Then use the
> Oracle accsess immigration tool to immgrate the file to oracle.
> I have done it and it is rather easier than SQL loader.
> Hope this helps?
> Anurag wrote:
> > Hi,
> > Does anyone know how to load data from a flat file.
> > I know that sql loader does this but you have to specify the
> column
> > names. I am looking for something generic .
> >
> > Any help will be appreciated.
> >
> > Thanks
> > Anurag
> >
> > also reply at
> > anurag_at_synergy-infotech.com
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's
> Discussion Network *
> > The fastest and easiest way to search and participate in Usenet
> - Free!
> --
> HAGHKHAH MAJID
> SYNES N.V
> I & I
> KAPEELDREEF 60
> B-3001 Heverlee Belgium
> Tel : +32 - 16 - 298455
> GSM: +32- 477 - 575029
> Fax : +32 - 16 -298319
> --------------C4FF021DE384BC2BD0594E40
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Hello,
> One possible way.
> If your file is not big, just read the file to Access
> database. Then
> use the Oracle accsess immigration tool to immgrate the file to
> oracle.
> I have done it and it is rather easier than SQL loader.
> Hope this helps?
>  
>  
>  
>  
> Anurag wrote:
> <blockquote TYPE=CITE>Hi,
> Does anyone know how to load data from a flat file.
> I know that sql loader does this but you have to specify the
> column
> names. I am looking for something generic .
> Any help will be appreciated.
> Thanks
> Anurag
> also reply at
> anurag_at_synergy-infotech.com
> * Sent from RemarQ <a
> href="http://www.remarq.com">http://www.remarq.com</a>
> The Internet's Discussion Network *
> The fastest and easiest way to search and participate in
> Usenet - Free!</blockquote>
> --
> HAGHKHAH MAJID
> SYNES N.V
> I & I
> KAPEELDREEF 60
> B-3001 Heverlee  Belgium
> Tel  :  +32 - 16 - 298455
> GSM: +32- 477 - 575029
> Fax : +32 - 16 -298319
>  </html>
> --------------C4FF021DE384BC2BD0594E40--

Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Fri Nov 26 1999 - 08:11:08 CST