Odd file format for import by bank

cturton

Registered User.
Local time
Today, 11:20
Joined
Apr 13, 2000
Messages
10
Hi:

Working with a bank that wants a file from us so they can import into their check reconciliation program. Got the export from the accounting program working for the info they need, but the bank guy says he needs a file structure like this:

(first row is header..don't worry about what the stuff means for now)
1234578990000000000000000
(rest of rows are details)
1234589000807091234
1234589000807093456

notice the line breaks between header and rows? Wouldn't this call for a line break and mess up an import program? Bank guy isn't a database person and is clueless

Thanks......
 
Have come across this before. In my case it was referred to as T File

Basically a fixed length string where positions contain certain info. If say position 1 to 6 contain value of gender then Male would require 2 "leading packers" to maintain the overall string length.

L

Basically did this with queries andbuilt up report, export to word as rtf

Frequently header row is a sort of pattern setter to confirm following format and has a leading code to set as header row.

White space is insignificant in practice I believe, at least was in my case
 
if you load the file to a table (using fixed width import spec) then you will have some blank rows. either get the table to have a mandatory field which will discard the blank rows, or clean them out with a query afterwards
 

Users who are viewing this thread

Back
Top Bottom