Large unix files - help please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave Holmes - 24 Sep 2003 20:10 GMT

I have a large unix file I am trying to parse into Access 2002 tables. The
file is 3.1Gb and is made up of 112 byte fixed length ASCII records
(including the linefeed character on the end of each record). I am opening
it as binary read, but after about 20 million records, I get a "Bad record
number" message on the Get. Does anyone know how to get around this in VB?
Failing that, does anyone know of a utility that will allow me to split the
UNIX file into more manageable sized chunks?
Thanx in advance
Dave

Reply to this Message

Ron Weiner - 25 Sep 2003 11:58 GMT

I am not positive, but I do believe that there is a 2.1Gb filesize limit in
all versions of windows at least up to win 2k.

112 * 20,000,000 = 2,240,000,000

Yikes!

You may want to search in one of the PD download libraries to find a
filesplitter that claims to handle files > 2GB

Ron W

> I have a large unix file I am trying to parse into Access 2002 tables. The
> file is 3.1Gb and is made up of 112 byte fixed length ASCII records
[quoted text clipped - 5 lines]
> Thanx in advance
> Dave

Reply to this Message