We are involved in a new project with our bank involving a 'Positive Payment' solution that requires I send them a file with the check summary data each time we do a check prining run. The example layout I received from this looks like this: (best viewed with a fixed font)

----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
RECONCILIATIONHEADER0075207990012345600000001000000005
20799001234560000071909000005100020040512 Abelman, Frayne & Schwab
20799001234560000071910000000200020040512 American Express                     
20799001234560000071911000000200020040512 Arizona Dept. of Revenue             
20799001234560000071912000000200020040512 Arrow Electronics Inc.               
20799001234560000071913000000200020040512 ASCOM Hasler Mailing Sys

I can mange the formatting if I can get the data into Access, but basically I need to grab the check number, check amount issue date, a void indicator if thats available, and the payee name.

can I do this?

If you are paying bills each day and printing them in a daily batch, then you can try looking at:

SELECT RefNumber, Amount, TxnDate, Memo, PayeeEntityRefFullName FROM BillPaymentCheck where BankAccountRefFullname='Checking' and IsToBePrinted is NULL and TxnDate={fn CURDATE()}