Thanks for the examples. They are a big help.
-Isaac
>Isaac,
>Just renaming doesn't make it CSV. A CSV is a comma delimited (text qualifier doublequotes) file where first line contains headers.
>
>Use customer
>Copy to customer type CSV
>oExcel = createobject('Excel.Application')
>With oExcel
> .Workbooks.Open(sys(5)+curdir()+'customer.csv')
> .visible = .t.
>Endwith
>
>*OpenText way
>#Define xlDelimited 1
>#Define xlTextQualifierSingleQuote 2
>Use customer
>Copy to customer type delimited with "|"
>Strtofile(chrtran(FileToStr('customer.txt'),"'",""),"customer.txt")
>Strtofile(chrtran(FileToStr('customer.txt'),"|","'"),"customer.txt")
>oExcel = createobject('Excel.Application')
>With oExcel
> .Workbooks.OpenText(;
> sys(5)+curdir()+'customer.txt',,,xlDelimited, xlTextQualifierSingleQuote,,,,.T.)
> .visible = .t.
>Endwith
>
Cetin
>
>>Thanks for the suggestion, however, I don't quite understand.
>>I did try renaming the file to a .csv and I still have the same issue. The fields in the file are delimited with a single quote. When the file is opened in excel the columns still have the single quote around them.
>>
>>If I open the file (a txt) manually in excel and go thru the options presented selecting the delimited option of single quotes the file opened correctly. I tried recording this as a macro and looking at what it does which is how I got to the options I did try. I'll keep searching.
>>
>>Regards,
>>-Isaac
>>
>>>>Hello,
>>>>
>>>>I have a comma separated file with single quote delimiters that I am trying to open in Excel 2000 using VFP 6 automation. I can't seem to figure out the parameter or its position to tell excel that the file used the single quote delimeters. Does anyone know what position it is and what value to use?
>>>>Here what I am doing ...
>>>>
>>>>lcFileName = "C:\MyFile.txt"
>>>>loExcel = CreateObject("Excel.Application")
>>>>loExcel.WorkBooks.Open(lcFileName, 2, 1, 1, 2, .F., .F., .F., .T.)
>>>>loExcel.visible = .T.
>>>>
>>>>
>>>>I have tried variations of parameters and values but can't get it right.
>>>>Any help would be greatly appreciated.
>>>>
>>>>Thanks,
>>>>-Isaac
>>>
>>>Isaac,
>>>Either use OpenText method where you can specify TextQualifier or as an easier way use CSV format. Excel opens it directly seeing extension.
>>>Cetin