Visual Foxpro 6 dbf to Dbase IV or III dbf

[Kevin]

Hi

I need a way to very quickly convert a Visual Foxpro 6.0 DBF file to a
Dbase III or Dbase IV format so I can read into my shop productions
grandfathered systems.

Getting frustrated over here. Just upgraded a accounting system to a new
package
that is built on Visual Foxpro 6.0 - we need to access this data via Dbase 3
or 4
format. Right now the only way I have found to read this is thru Lotus
Approach.

Our use:
User enters PO into our accounting system. User then switches to Lotus R5 in
which
a customized macro asks user for a PO number. User enters a PO number (that
he just
entered into the accounting system) - Lotus macro imports the accounting
system DBF
and searches for the PO, looks it up on a Lotus table, steals info then
prints 3 copies
on a pre-determined form, clears everything and loops back to wait for user
to enter
another PO into dialog box.

Before the upgrade we could do this without a problem.

Thanks for any assistance

Kevin Real
KE...@EXTRUTECH.COM

[Gabriel Guerrero]

I dont know if is the solution, but see the copy command with the type
foxplus option.

Kevin <ke...@extrutech.com> escribió en el mensaje de noticias
GynG4.36881$YU2.6...@typhoon.ne.mediaone.net...

[Ricardo E. Sanchez]

Hi kevin, you can use the COPY TO command, this is the step :

USE <Mytable>
COPY TO <Path\FileName> TYPE FOXPLUS

If you need convert to others format, see the HELP for COPY TO
regards,

Ricardo Sanchez
El Salvador,C.A.

Kevin <ke...@extrutech.com> wrote in message
news:GynG4.36881$YU2.6...@typhoon.ne.mediaone.net...

[Kevin]

Thanks

Well - thanks for the help.
The accounting program was written in VFoxpro 6 - but I did not write it and
don't have
access to the source code.

In previous versions I could open the generated .DBF's but now I can't.
The DBF's need to be compatible with dBase III or IV. That is what my Lotus
spredsheet can read in. I cannot use ODBC because I have yet to find a
VFoxpro 6.0
16 bit ODBC driver.

I am using Lotus R5. Thanks,
Kevin

"Ricardo E. Sanchez" <ric...@duraflex-politex.com> wrote in message
news:#0v7U7vn$GA.2052@cppssbbsa06...

[Marcelo Trinidad]

Kevin, perhaps the tables that you see they are part of a database (.DBC),
if they are... then is more difficult to open in Dbase, first you should see
if exist a database (.DBC), otherwise you would have to open the tables in
vfp5 or vfp6 and run the command said above:

COPY TO <Path\FileName> TYPE FOXPLUS

Regards

Marcelo T.

"Kevin" <ke...@extrutech.com> escribió en el mensaje

news:1hLG4.38433$YU2.6...@typhoon.ne.mediaone.net...

[anthony....@gmail.com]

On Tuesday, April 4, 2000 at 3:00:00 AM UTC-4, Kevin wrote:
> Hi
>
> I need a way to very quickly convert a Visual Foxpro 6.0 DBF file to a
> Dbase III or Dbase IV format so I can read into my shop productions
> grandfathered systems.

It's 16 years later, but maybe this will help the next person to find it.

OpenOffice/LibreOffice v4.x Calc can open FoxPro 6 DBF files. If the FPT is in the same folder, opening the DBF will automatically include the DBT data.