Phil:
I do this type of import every day. The command and syntax you need will
look something like this:
LOAD tempcaus FROM causcode.dat AS FORMATTED USING +
cause 1 3, +
causdesc 4 48, +
dept 49 52
The numbers indicate the starting and ending character on the import file.
So cause 1 3, means load the cause field in the tempcaus table with
characters 1 through 3 from the import file, etc. See the online
documentation for more information.
Hope this helps.
Thanks -- Mike
> -----Original Message-----
> From: Phil Nolette (NCS Group, Inc.) [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 27, 2001 02:52 PM
> To: [EMAIL PROTECTED]
> Subject: Fixed Field Import
>
>
>
>
>
> Does anyone now of a process to import 50K rows of data that are fixed
> field
> without using a middle product such as excel to put it in csv or tab
> delimited format?
> Would appreciate any help.
>
> Phil
