ACL操作指导-1_Cleve Isaca Mtg - ACL Part 1 of 3 - ImportingData.pdfVIP

Section 1: Importing Data into ACL Computer Assisted Auditing Techniques (CAATs) Section 1: Importing Data into ACL Section Objectives At the end of this section, you should be able to: • Import the following raw data file types into ACL: ─Excel ─Delimited ─Report • Perform a simple series of steps to efficiently import a second flat file with identical structure to the first • Execute a command to efficiently import a second report file with identical structure to the first Copyright © 2008 Deloitte Development LLC. All rights reserved. 2 Section 1: Importing Data into ACL What types of raw data files can ACL import? • CR – Carriage Return • LF files – Line Feed Files • Mainframe database files • CR/LF – Carriage Return and Line Feed • Multiple-record-type files • Databases – .dbf files • Proprietary variable-length files • Delimited files • Report files • Fixed-length files • Segmented files • Flat files • Variable-length files • Hierarchical and • Excel files relational databases The types in boldface will be reviewed in this section. Copyright © 2008 Deloitte Development LLC. All rights reserved. 3 Section 1: Importing Data into ACL How ACL Imports Raw Data Files Stored within Stored outside