Re: How in the world do you easily format data for loading?
From: <bonanos_at_yahoo.com>
Date: Mon, 01 Feb 1999 06:59:26 GMT
Message-ID: <793jcc$9f9$1_at_nnrp1.dejanews.com>
Date: Mon, 01 Feb 1999 06:59:26 GMT
Message-ID: <793jcc$9f9$1_at_nnrp1.dejanews.com>
Hi
> I recently obtained several 'largel files of data that was spooled in
> sqlplus from a client site. I am curious as to how I can 'automate' and make
> the process fo using SQLloader to load te data easier without having to go
[Quoted]
> in with VI (no laughing out there) and formatting the data...ie. setting up
> all char fields with surrounding ' etc...
The easieast way to do this that I know of is to first import the data into Microsoft access and use it's export function, where you can specifiy how to delimit the data.
[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 01 1999 - 07:59:26 CET