Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default 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
?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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
?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel bar chart formatting of bars to change colors as data change JudyT Excel Discussion (Misc queries) 1 January 24th 07 06:07 PM
Use date modified to change format & create filter to track change PAR Excel Worksheet Functions 0 November 15th 06 09:17 PM
making copied cells change with change in original cell Jennifer Mcdermeit Excel Worksheet Functions 2 July 20th 06 04:58 PM
change info in other cells when i change a number in a drop list? macbr549 Excel Discussion (Misc queries) 2 September 11th 05 02:07 AM
Change workbook sheet reference using cell A1 to change a vairable Reed Excel Worksheet Functions 4 January 20th 05 07:15 PM


All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"