>>>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.

I import spreadsheets created in 2007 all the time - the trick is to get the originator to save it as an Excel 5.0/95 workbook