Save VFP 5.0 as Dbase III Plus compatible 2

[Idokyoku2]

Hello all,
My manager is stuck on Dbase III plus. That being said. . .Does anyone know what the command is? I'm exporting from SQL Server as dbase III, but it will not open using dbase. I can, however, open it with VFP?

I'd appreciate your input.

David

 

[wgcs]

Try opening the file in Excel, then saving as a DBase III file.


- Bill

Get the best answers to your questions -- See FAQ481-4875.

 

[Stella740pl]

Don't have dBaseIIIPlus anywhere around for many years, so cannot test this, but did you try to save files in FoxPro2.x or FoxPlus format? Would it be able to read it then?

Just save VFP files as

COPY TO ... FORMAT FOX2X
or
COPY TO ... FORMAT FOXPLUS

 

[Neil Toulouse]

Just to be nit picky(!) Stella640pl's syntax should read:

COPY TO ... [b]TYPE[/b] FOX2X

Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[Neil Toulouse]

You could probably try saving the data as Stella740pl suggested, and then force load it back into Excel as dBaseIII and see if there is any weird behaviour?

I like work. It fascinates me. I can sit and look at it for hours...

 

[Stella740pl]

FatSlug,

You are right about the syntax. Sorry, Idokyoku2. Was thinking about something else.

 

[Idokyoku2]

Wow!!!!

Been swamped and just logged in.

I new it was something fox2x.

Tested with success.

Thanks to all for your response.

David