1748117 Members
3731 Online
108758 Solutions
New Discussion юеВ

Re: Change to dbf format

 
SOLVED
Go to solution
juno2
Super Advisor

Change to dbf format

I have a program that generate a .prn file from our system , I would like to read this file by foxpro , how to change this .prn file to a dbf format ? Thanks in advance.
6 REPLIES 6
Yogeeraj_1
Honored Contributor
Solution

Re: Change to dbf format

hi,

is your .prn file of ASCII (text) format?

revert

regards
Yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
juno2
Super Advisor

Re: Change to dbf format

Hi Yogeeraj ,

Yes , it is txt format. thx.
Massimo Bianchi
Honored Contributor

Re: Change to dbf format

Hi,
if it is plain text, you can inport in in Excel and then export in DBF.

HTH,
Massimo

Yogeeraj_1
Honored Contributor

Re: Change to dbf format

hi again,

As Massimo said above if your file is in plain text, one easy way is to import it in excel and conver to DBF format.

Is it a once-off task? Can it be done manually or to you want to automate it?

If the latter, you will have to write a procedure in foxpro to import the text file.


regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
juno2
Super Advisor

Re: Change to dbf format

Thx all reply , but in my case , the dbf file is used by users , they have no technical knowledge to convert the file , is there any tools or method that can convert the file automatically ? thx
juno2
Super Advisor

Re: Change to dbf format

I know some tools that can used to convert the file from txt format to dbf format , can I write some conversion procedure to make it change ?thx