Expert: Markish - 8/25/2008

Question
Hi sir Markish..

i am a mere person with the common knowledge of computer.
I see in here you can provide answer for critical questions
maybe you can help me out.. in the office where i'm working, is using FOXPRO (ver. 2.5) which is operated from DOS system.

My company is having a problem and want to convert some databases (the General Ledger - GL) from FOX PRO to xls in ms excel.. (i'm intending to back up the data to new hard disk)

i do download some programs by googling but i still can't solve the problem. maybe because my lacking of knowledge..

the puzzling part for me is because the database can't be found anywhere in windows, i think it is somewhere in the DOS systems. it is simpler if the Foxpro database's is inside the windows (the programs usually request use to browse from certain directory- but i can' locate it in windows)

can you help me with your guidance.. or maybe suggest me the proper program to use..

I am very grateful with anything you can help..
thank you very much

Answer
Hi Delly,
   Sorry for the delay in my response. Exporting a Fox 2.5 Data to Excel is quite straight forward.

Data in FoxPro/VFP are stored as .DBF files. You have to search for them in your application folder. Unless the application / programmer has designed the application to look from some remote location (file server in your network, search for the DBF files in that location.

Once you find it, there are two options,

You can directly open the DBF from execl.

Otherwise, you can open the dbf in the FoxPro and export the data to excel...

use TableA  && Your DBF File name with fullpath
copy to test.xls XLS

The above set of commands will open the tableA and copy the contents to test.xls


Hope this helps..
best regards,
Markish

http://markishonline.com