Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |