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