More than 2 gb. table

[fr]

Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
transactions records". I need to work with it and "break" it down into several
manageable tables.
Any ideas of how to open or split the table even if some data is lost.

Thanks

[Nancy Folsom]

A series of archive tables?

"fr" <agromat.ramirez@codetel.net.do> wrote in message
news:3981e2ed$1@news.devx.com...
>
>
> Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
> transactions records". I need to work with it and "break" it down into
several
> manageable tables.
> Any ideas of how to open or split the table even if some data is lost.
>
> Thanks

[Fred - Armoni]

fr (?)

If you can't open the dbf anymore, you can deal with low level file (maybe, i
don't know the limit).

isolate the header of the dbf (the desciption of dbf files is in the help of fox)
and knowing the length of a record (hope you know) without forget the deletion
marker, you can read them one by one...

HTH


fr a écrit :

> Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
> transactions records". I need to work with it and "break" it down into several
> manageable tables.
> Any ideas of how to open or split the table even if some data is lost.
>
> Thanks

--
Fred - Armoni (France) - FE AVP&Cie
Département Français, La Rochelle

[Fred Taylor]

If you're table doesn't have memo fields (or you don't care about them), you
should be able to open the table with a hex editor, remove the header info,
and save it under a new name. Now, you can cut this resultant file into as
many pieces as you need since it's essentially now just a text file of fixed
length records.

--
Fred


"fr" <agromat.ramirez@codetel.net.do> wrote in message
news:3981e2ed$1@news.devx.com...
>
>
> Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
> transactions records". I need to work with it and "break" it down into
several
> manageable tables.
> Any ideas of how to open or split the table even if some data is lost.
>
> Thanks