Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement