General information
Category:
Coding, syntax & commands
Hi Sergey. Thanks for your reply.
Have worked around it. Used Excel to copy the file out to a 95 XLS type , and then imported in VFP with Appe from Type XLS
Regards,
Gerard
>AFAIK, that part is not configurable in Excel. You'll have to loop through Excel records/columns and build export file himself.
>
>>I have tried a few different options to output a text file (or CSV) file form Excel (Office 97) , but having a problem with double quotes
>>Some of my data has a double quote at the end to signify an inch)
>>Each time I export, it puts a Doule Quote at the start and end of the text
>>e.g.
>>Pipe3" comes out as ->>> "Pipe3"" (An addiitonal Double Quote before the text and an additional Double quote at the end of the text
>>All I want is the single Double Quote (i.e. to export exactly the data without appending anything (other than a comma to separate the fields)
>>I have tried Csv, Txt, Tab Delimited but in all cases Excel is outputting the additional DoubleQuotes
>>
>rd
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only