ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i change something from CSV to XML? (https://www.excelbanter.com/excel-worksheet-functions/187168-how-do-i-change-something-csv-xml.html)

research help

how do i change something from CSV to XML?
 
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
?

Martin Fishlock

how do i change something from CSV to XML?
 
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.


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


"research help" wrote:

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
?


David Biddulph[_2_]

how do i change something from CSV to XML?
 
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

"research help" <research wrote in message
...
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
?





All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com