Hi Peter,

Thanks so much for the reply. Unfortunatley, all the data I'm sending in this file is the critical for this export. I agree that exporting memo files is tenuious, but using the low-level file functions gives me more control over the line feeds and that is really not a problem. However, I have e-mailed the vendor with the information you supplied and I'm recommending 1) I sent the dbf/fpt for a direct import and/or 2) she checks her version of Access and upgrades if necessary.

Thanks again, I'll let you know how this resolves if you're interested.

Regards,

Rob

>Hi Rob,
>
>I don't know what version of Access your vendor is using, but it should be no problem to import a foxpro table directly, which is the approach I would recommend, if you have very long descriptions. The 32767 limit is the limit for string-type variables in older access versions, and it could be, that this limit still is enforced in some import code. Anyway, 32K+ data on one line in a delimited file is a lot. I never recommend to export MEMO field data in delimited files, you can never be sure how embedded line feeds will import into the target system.
>I therefore recommend that you send the foxpro table itself (or just the necessary data exported to a foxpro table) to your vendor. (Remember to also send the FPT file, which contains the memo field data)
>Cheers
>Peter
>
>>Cheers All,
>>
>>I have a tab delimeted file that I'm sending to a vendor. According to the vendor's spec sheet, the "description" field in my file can be "unlimited" in length. Some of my descriptions are VERY long, and I'm using a memo field for description. I'm exporting the file using the following:
>>
>>#Define TABULATE chr(9)
>>#Define CRLF chr(13)+chr(10)
>>tcTable = 'myTable'
>>handle=fcreate(forceext(tcTable,'txt'))
>>Scan
>> For ix = 1 to fcount(tcTable)
>> lcField = field(ix)
>> =fwrite(handle,transform(&lcField)+iif(ix < fcount(tcTable),TABULATE,CRLF))
>> Endfor
>>Endscan
>>=fclose(handle)
>>
>>Then I'm sending myTable.txt to the vendor. On the vendor's side, she's trying to roll the file into Access and she's getting the following error:
>>
>>'The 'Field 11' contains a start psoition of '32804'. The maximum start position allowed is 32767.'
>>
>>She's asking me for advice, but I don't know Access. I'm assuming access has a maximum character position as the error messages states, but the fact that the vendor's specs say the description can be "unlimited" in length seems to contridict this.
>>
>>Any advice or info would be greatly appreciated!
>>
>>Thanks!
>>
>>Rob