Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

data xfer of CSV files

Aug 9, 2008 11:01PM PDT

data xfer of CSV files Question

I used to write csv files in XP Works8 note pad.
Strings of data separated by comma, ie; 02,Rooster Cogburn,1975,Rooster Cogburn,x.

Then I would transfer the data CSV file to XP Works8 data base. Via cut & paste
The above line would be entered automatically into Five (5) separate fields or columns
of XP Works8 database or spreadsheet.

The same procedure does not work for me in Vista Works9.

What is the procedure for Vista Works9?

Discussion is locked

- Collapse -
Most likely same.
Aug 9, 2008 11:10PM PDT

BUT in the versions of Office I use all have configuration options to tweak how to handle .CSV files. I do not own Works or have access to it but it's a fair bet that it has some configuration feature.

-> Why not open that .CSV file with Works and see what happens rather than a cut and paste? If it opens proper you can cut and paster from that sheet to yours.
Bob

- Collapse -
data xfer of CSV files
Aug 9, 2008 11:34PM PDT

Bob Thanks for the reply.
I've just recently upgraded to Vista. So I'm learning all over again.
I am origianaly coping info. from the internet, info ie: movie, music ,video data info. Coping it into note pad removes the formating. I edit the information I require for my data base template, then transfer it to the db and/or spreadsheet using the CSV formating. Again it worked absolutely great with XP,win98,95, but not with Vista. Vista/works9.0 does not reconize the commas.
Help.

- Collapse -
Then we'll have to give up.
Aug 9, 2008 11:39PM PDT

I noted that in all versions of Office I have there are options about which is the delimiter but I do not have Works.

However Open Office works fine here and is free at http://www.openoffice.org
Bob