Removing Multiple Headers From Imported File

J

June

I'm required to import a speciifc txt file into Access every day, when
importing this txt file into an access (table) it repeat the header
information multiple times through the document. The location/placement of
these various headers do change and are based on the number of transactions
and employees. Could some-one help me. I would like to remove/delete all
header information from document/table.

Thanks in advance. (See example of imported document below)

RECONCILED PURCHASE CARD ORDERS JUN 29, 2007@10:29:28 PAGE 1
P.O. DATE DATE RECONCILED ORDER # $AMT TYPE(S/D)
VENDOR DESCRIPTION
STATUS
DOC-REF # RECONCILED $AMT RECONCILE VENDOR FINAL CHARGE
--------------------------------------------------------------------------------
BUYER: BROWN,LANA R

MAY 02, 2007 JUN 28, 2007 999-Z4161 60.00 DETAILED
UNM Health Sciences Center ACLS Cards for students of the Apri
Transaction Complete (Amended)
Z99921779010001 60.00 U N M H - CLINIC YES
RECONCILED SUBTOTAL - $60.00



RECONCILED PURCHASE CARD ORDERS JUN 29, 2007@10:29:28 PAGE 2
P.O. DATE DATE RECONCILED ORDER # $AMT TYPE(S/D)
VENDOR DESCRIPTION
STATUS
DOC-REF # RECONCILED $AMT RECONCILE VENDOR FINAL CHARGE
--------------------------------------------------------------------------------
BUYER: IASIAS, ALFRED

OCT 16, 2006 JUN 28, 2007 999-P70555 7.95 SIMPLIFIED
SAMMONS PRESTON Item returned, will pay for shippin
Transaction Complete (Amended)
C99962969001010 40.01 SAMMONS PRESTON ROLYAN YES
C99963529001007 -32.06 SAMMONS PRESTON ROLYAN NO
Z99920369001006 -32.06 SAMMONS PRESTON ROLYAN NO
RECONCILED SUBTOTAL - $-24.11


RECONCILED PURCHASE CARD ORDERS JUN 29, 2007@10:29:28 PAGE 4
P.O. DATE DATE RECONCILED ORDER # $AMT TYPE(S/D)
VENDOR DESCRIPTION
STATUS
DOC-REF # RECONCILED $AMT RECONCILE VENDOR FINAL CHARGE
 
J

John W. Vinson

I'm required to import a speciifc txt file into Access every day, when
importing this txt file into an access (table) it repeat the header
information multiple times through the document. The location/placement of
these various headers do change and are based on the number of transactions
and employees. Could some-one help me. I would like to remove/delete all
header information from document/table.

Thanks in advance. (See example of imported document below)


What information is header, and what is to be imported; and what is the
structure of the table into which you're importing it? I strongly suspect
you'll need to write some VBA code to do this, or to see if the generation of
the text file can be changed - it certainly looks like a Report generated from
a database of some sort, perhaps you can get a closer link to the database
itself.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top