Golf Scores from Excel Spreadsheet  
 
 
 


Connection String Used:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=......\portals\5\GolfScores.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

SQL commands shown to illustrate how to access the data in a shreadsheet - typically hidden



Player
DatePlayerGolf CourseParScore
01-Jul-09PaulThe Dells7280
01-Jul-09BobThe Dells7279
02-Jul-09PaulSummerHill7078
02-Jul-09BobSummerHill7079
03-Jul-09PaulOaklawn5460
03-Jul-09BobOaklawn5455
04-Jul-09PaulOakRidge7072
04-Jul-09BobOakRidge7079
05-Jul-09PaulThe Dells7288
05-Jul-09BobThe Dells7272
06-Jul-09PaulSummerHill7072
06-Jul-09BobSummerHill7072
07-Jul-09PaulOaklawn5472
07-Jul-09BobOaklawn5472
08-Jul-09PaulOakRidge7072
08-Jul-09BobOakRidge7072