Export Flat File from MS SQL
Posted on 2004-10-12
I got a job that request me to submit a flat file to a bank. this flat file using the EDIFactoring format for IDEAL Account Receivable System. and the file must have a fixed format, eg to start a record:
Position 1-5 RecordID Lenth 5 Value='ABC01'
Position 6-19 Filter Lenth 14 Value is space
I only know a flat file is a one dimemsion data file can be stored as a .txt file.
May I know if it's possible to use asp to generate such a file? If possible how to ? Thank you very much!!