How can I read data from an Excel Spreadsheet using SilkTest?

Data can be read from Excel spreadsheets using the SilkTest DB_Tester functions. The following is a sample piece of code that will illustrate. This code uses simple SQL to read from Excel, the user can write specific SQL statements to perform more complex data retrieval.

[-] testcase Database_example ()
 [ ] //To tell DBTester what DB to connect to
 [ ] STRING sConnectString = "DSN=Test;DBQ=C:\example.xls"
 [ ]
 [ ] //Connect to database and keep a reference to it
 [ ] HANDLE hDB = DB_Connect (sConnectString)
 [ ]
 [ ] //SQL Command to be carried out on DB
 [ ] STRING sSQL = "SELECT * FROM `Sheet1$` `Sheet1$`"
 [ ]
 [ ] //Execute the SQL Statement and keep a reference to the resulting table
 [ ] HANDLE hSQL = DB_ExecuteSQL (hDB, sSQL)
 [ ]
 [ ] //Variable to hold any data retreived from the database
 [ ] LIST OF ANYTYPE laData
 [ ]
 [ ] //Query result table and copy data into variable
 [+] while (DB_FetchNext(hSQL, laData))
 [ ] //Print one record at a time to a results file
 [ ] Print (laData)
 [ ]
 [ ] //Clean Up and Disconnect
 [ ] DB_FinishSQL (hSQL)
 [ ] DB_Disconnect (hDB)