Thanks Duey and all the others who replied. We now have enough information
to attack the problem.
By the way, the golf game has significantly improved. That too is expensive
but fun.
Phil
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Duey Heffelfinger
Sent: Wednesday, June 27, 2001 6:36 PM
To: [EMAIL PROTECTED]
Subject: Re: Fixed Field Import
Phil,
I think I can answer this one. Use the
LOAD tablename FROM filename AS FORMATTED USING
colname firstposition lastposition, etc.....
Example
LOAD test FROM temp.dat AS FORMATTED USING id 1 10,
name 11 50, grade 51 60
Hope this helps.
Duey
P.S. How's everyone's golf game this year?
From: "Phil Nolette \(NCS Group, Inc.\)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Fixed Field Import
Date sent: Wed, 27 Jun 2001 14:52:05 -0400
Send reply to: [EMAIL PROTECTED]
> 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
>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Duey Heffelfinger, Director of Computer Services +
+ E-mail: [EMAIL PROTECTED] Dana College +
+ Phone : 402-426-7289 2848 College Drive +
+ Blair, Nebraska 68008 +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ If you can dream it, it can come true! +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
