>>Hi
>>I am trying to copy data from an excel spreadsheet to a DBF table. The excel has (simplied) three columns:
>>
>>
>>Column 1 Column 2 Column 3
>>21 Main Street, Atp 12 John Smith Boston, MA 02022
>>
>>
>>If I save this excel to CSV command delimted then I have tough time to append from the CSV into a DBF since the comma withint each column "breaks" things. If I save this excel as tab delimited then more than one column goes into the DBF field. How would you suggeste I save as this spreadsheet and append into a dbf?
>
>Delimited by tabs.
I tried that. But when I then append from this - tab delimited - file, more than one column goes to the DBF field. Do you have to create the DBF with fields that match the length of the column in spreadsheet exactly?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham