[MLUG - DISCUSSION] MS Excel DSN & Perl

["Ross, Matt" <EMAIL:PROTECTED>]

Has anyone ever used an excel file in ODBC DSN?
I'm trying to figure out what's wrong with my script.

Here's the error I got:
<snip>
DBD::ODBC::db do failed: [Microsoft][ODBC Excel Driver] Could not delete
from specified tables. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) at
\\md47679\scripts\INTOSU~1.PL line 24.
</snip>

Here's the perl script I'm using to connect:
<snip>
my $dbhInto = DBI->connect( "DBI:ODBC:intosurvey", "", "",{ RaiseError => 1
} ) or die "Unable to connect: " . $DBI::errstr . "\n";            
$dbhInto->{LongReadLen} = 64000;
$dbhInto->do("Delete from [survey\$]");
</snip>
--
To unsubscribe, go to http://mlug.missouri.edu/members/edit.php

Archives are available at http://mlug.missouri.edu/list-archives/