Help for this page

Select Code to Download


  1. or download this
    # Set the DSN for ODBC connection

...

my $ExcelHandle = DBI    ->connect("dbi:ODBC:$DSN", '','')
    or die "$DBI::errstr\n";
  2. or download this
    my $Table    = '[Sheet1$]';  # This translates to Sheet1

...
my $ExcelQuery    = $ExcelHandle    -> prepare( $QueryStatement );

$ExcelQuery    -> execute();