>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
I think you need to open the file through Ole automation and then save it as CSV using SaveAs option. I have the code, but you can also record the macro and convert the syntax to VFP.
If it's not broken, fix it until it is.
My Blog