The data source is the name of the file which contains the data being audited. There are three primary types of data sources:

 

 

• Excel
• Access
• text

Excel workbook

• Sheet within a workbook
• Named range on a worksheet
• Specified range on a worksheet (e.g. c10:g50)

Access Data base

• Access table
• Access query

Text File

• Tab separated value with headers
• Tab separated value without headers
• Comma separated value with headers
• Comma separated value without headers
• Fixed length columns ("print" format)
• Columns separated by special characters, e.g. "|"

Both Excel 2003 and 2007 formats are supported. Similarly, both Access 2002 and 2007 are supported. Text files in the format of comma separated values (CSV) and tab separated values (TSV) are supported.

An example of an Excel data source is the name of the workbook, e.g. "C:\Audits\Audit1074\Accounts Payable Data.xls" (without the quotes).