General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
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