>>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
Import command doesn't work for Excel 2007.
If it's not broken, fix it until it is.
My Blog