DTS Foxpro 2.6

[sac11585]

Can DTS in SQL 2K converts SQL data to dbf file that is compatible to Foxpro 2.6 DOS version? Also can the DTS converts data to Foxpro index file (.cdx) and memo field (.fpt).

If not, what are the alternatives? Converting to these files is necessary because the current dbf interfaces to few other foxpro applications, which means these foxpro applications would expect (.dbf, .cdx, .fpt) these files.

Hope this make sense. Thanks for advance.

 

[jbenson001]

I would use a central SQL DB and have the foxpro apps use it.

 

[sac11585]

Thanks for the quite reply. Our scope of the new application is very limited. We do not have plan to rewrite/update these other foxpro applications at this moment.

Sounds to me that this task is not doable, it requires the other foxpro apps to be modified. Is it true?

 

[jbenson001]

In poking around I only found a way to export to a Visual FoxPro DB not a DOS version. I don't think it would create the idx and fpt files.