Mirrored

So, I was unsure where this would go, but it is Database related.

Basically, I have to submit a flat file to a database and was wondering if there was some sort of software that would help me make a flat file with multiple records.

The file itself is character length based.

There must be a header record that is 2000 characters in length with 5 fields (4 contain information, the 5th is empty. They are all fixed length and must be filled with spaces)
Then there must be multiple lines for records with quite a few fields (100+ fields, 2000 character length, filled with spaces).
Then there must be a trailer record.

Any idea on an easy way to generate a flat file like this? Or just the records and I can add the header/trailer in notepad++

I think this fixed length thing is driving me crazy!

Adak

Access, or any database software could give you something like this. All databases expect to have multiple records, and for each record to have multiple fields, as well. Nothing startling there.

There may be free flat file type databases programs around. Google for that.

You can code up what you want in a program of course. The way you've asked this makes me think you have very little experience programming, so it might be a struggle for you, in a short time frame, to work out the kinks of the program.

Quick and easy answer is to use a database program. If you want to program it, and have the time/experience to get started, then lay it on us, and we'll assist.