Parsing text file

B

bdmir

Joined
Mar 31, 2011
Messages
1
Reaction score
0
Hello,
I have a text file(tab delim) with data and I want to create report. Here is the content of text file:

HD John Smith j.smith(eta)testmail.com
CT service 1 5$
CT service2 1 6$
CT service3 4 7$
FT total 6 18$
HD Cindy Surname c.surname(eta)testmail.com
CT ... ... and etc.

HD- is report header, CT-report content(invoice items), FT-footer.

Now I'm splitting this file to two tables, in first tbl is assigned customer id, in other tbl customer's invoice items. Then I create join query and out of it report.

The question is: is it possible, to create report out of this kind of file reports, without splitting? if yes, then how.
 
Last edited:

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

Similar Threads

parsing text 1
Parsing a text file 4
How can I use Access track employment positions and candidates 1
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
How To Use PowerPoint Manage Recruit Employees? 1
How To Use Excel Manage Recruit Employees? 1
How Can I User Word Manage Recruit Employees? 1
How to create a new empty text file? 1

Top