>>What is the maximum for the Excel column's width?
>>
>Looks like it could not be done using DBF4 format. Is where a simple way to save other formats into DBF without knowing data structure in advance?
>
>Thanks in advance.
I was thinking of using the other formats (TAB delimited, probably). Create the original table with the fields of 250 chars each and append from TAB Delimited. But it looks a bit involved and convoluted.
May be I'm missing some options in SaveAs method?
Or do you have any more ideas?
UPDATE. I was able to make some progress using this:
if .columns[m.lnI].columnwidth > 15
.columns[m.lnI].columnwidth = 240
endif
However, I'm having trouble with dates. This file is created at work, then send to the third party and then additional data is imported. The fields I've created came up correctly in D format or numeric format. But the fields which were filled by the third party are converted wrongly. Date fields have 9 or 7 characters, which is obviously not enough. Is there a way to make sure the fields are created as dates? These dates may be empty for all cells.
Thanks in advance.
If it's not broken, fix it until it is.
My Blog