T
tmb
We have a vendor who want's their orders from us to be submitted via FTP'ing
a file up to their server. (EDI)
They give us 2 choices... ASCII fixed length or X.12.
THE PROBLEM it seems to me is that each record has a different length... and
each record has a different number of fields.
For the ASCII Fixed Length option...
- The "Order Batch Header" record is 35 bytes long
- The "Order Header" record is 225 bytes long
- Etc, etc for additional records to comprise the order
For X.12 Same problem but the use an astrik "*" as a delimiter it seems.
I'm guessing that in either case each 'record' is terminated with a
'cr/lf''
And, they will be sending data back to us as well by the same methods
regarding shipping status, etc.
Can anyone give me any tips on how I may do this with Access?
thanks - tmb
a file up to their server. (EDI)
They give us 2 choices... ASCII fixed length or X.12.
THE PROBLEM it seems to me is that each record has a different length... and
each record has a different number of fields.
For the ASCII Fixed Length option...
- The "Order Batch Header" record is 35 bytes long
- The "Order Header" record is 225 bytes long
- Etc, etc for additional records to comprise the order
For X.12 Same problem but the use an astrik "*" as a delimiter it seems.
I'm guessing that in either case each 'record' is terminated with a
'cr/lf''
And, they will be sending data back to us as well by the same methods
regarding shipping status, etc.
Can anyone give me any tips on how I may do this with Access?
thanks - tmb