Re: Import taking over 24 hours

Douglas,

Have you considered just looking at the file with a hex editor and trying to
figure out the format on your own?  Their documentation of the data might be
proprietary but it's your file and, unless there is something in the
contract, you should be free to reverse engineer the file format.  If it's a
stream file it can't be all that complicated.  The file might have an index
that would complicate the format.  If it doesn't then it might be pretty
simple to figure it out.  Maybe the file has some header format data at the
front of the file (field and record sizes and such) which you have to skip
over to get to the record data you're interested in.

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

Douglas wrote

> No, that's what I am trying to get or at the least, the file layout so we
> can extract the data directly.....