Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

The Art of Parsing

Let’s suppose that your boss comes to you with what he thinks is a wonderful idea. The phone company has sent him a disk containing the phone calls for the past month. They can provide this on a monthly basis. He wants you to transfer this list to an Access database so that he can tell who is making the longest calls. When you finally see the phone bill, it looks something like Table 19.2 (minus several thousand records).

Table 19.2. Raw Data Text File for the Phone Bill Table
2790017 9185436525 20001215 351NGTBixby 13538547 24 168
2790017 9184681269 20001129 824DAYBixby 10538547 18 180
2790017 9184681181 20001227 101NGTBixby 3538547 4 28
2790017 9185459191 20001227 102NGTBixby 2538547 2 14
2790017 9185448823 20001227 301NGTBixby ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book