Message
From
04/03/2010 02:05:52
To
03/03/2010 16:20:31
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01452345
Message ID:
01452418
Views:
63
>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
>
>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
I run courses in Business Management and Marketing