>Is there a quick way to convert myfile.xls to myfile.cvs.? I want to open the cvs as a textfile however showing the text,text,text not as an excel file.
>
>I found (using 2007) that i can rename xls to cvs - opening it however, has excel asking to inspect data then resaving as true CSV (in other words it knows it's a fake). Renaming then the csv as txt poses no problem.
>
>
>thanks
>k
Why don't you import the spreadsheet and copy it to a csv file as follows
* create dbf from Excel file
IMPORT FROM c:\blankmanis TYPE XLS
* copy table to csv file
SELECT blankmanis
COPY TO c:\blankmanis.txt type csv
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing