how do i change something from CSV to XML?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

research help - 12 May 2008 23:08 GMT

I have a CSV file, and I am trying to create a DBF out of it, but everytime I
change it all the values go into collum A, how do I stop this from happening
and how do I change it to an XML file, or a TXT file
?

Reply to this Message

Martin Fishlock - 13 May 2008 12:32 GMT

There are a number of programs out there that will convert CSV to dbaseIII
(dbf) files.

Otherwise it should work on excel.

Use open and select the csv type and if all the items go into column 1 just
use text
to columns on the data menu to seperate them and then save as DBF.

Signature

Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.

> I have a CSV file, and I am trying to create a DBF out of it, but everytime I
> change it all the values go into collum A, how do I stop this from happening
> and how do I change it to an XML file, or a TXT file
> ?

Reply to this Message

David Biddulph - 13 May 2008 13:17 GMT

To answeryour final question, to change from csv to txt, just rename it.
CSV is comma separated text, so it is readable as a text file.
--
David Biddulph

>I have a CSV file, and I am trying to create a DBF out of it, but everytime
>I
> change it all the values go into collum A, how do I stop this from
> happening
> and how do I change it to an XML file, or a TXT file
> ?

Reply to this Message