LOAD tablename FROM filename AS FORMATTED USING columnname start end, ...
for example:
LOAD Invt FROM Invt.dat AS FORMATTED USING Invt 1 10, Desc 12 25, OnHand 27
32, etc...
----------------------------------------------------------------------------
--------------------------------------------------------
> -----Original Message-----
> From: Phil Nolette (NCS Group, Inc.)
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 27, 2001 11:52 AM
> 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
