hi,
<snip perldoc DBD::ODBC>
Connect without DSN The ability to connect without a full DSN is introduced
in version 0.21.
Example (using MS Access): my $DSN = 'driver=Microsoft Access Driver
(*.mdb);dbq=\\\\cheese\\g$\\perltest.mdb'; my $dbh =
DBI->connect(``dbi:ODBC:$DSN'', '','') or die ``$DBI::errstr\n'';
The above sample uses Microsoft's UNC naming convention to point to the
MSAccess file (\\\\cheese\\g$\\perltest.mdb). The dbq parameter tells the
access driver which file to use for the database.
</snip>
HtH
=====
iVAN
[EMAIL PROTECTED]
=====
----- Original Message -----
From: Andre Andreev <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 5:54 AM
Subject: Out .mdb to .xls file
> I want to pass .mdb file or a number of .mdb file as a parameters to a
Perl
> program which should read all tables from .mdb and display the results as
> .xls for every table.
> I guess after that step I'd like to (if table and fields names are known)
> run query against database and ,again, put results in .xls file.
>
> Perhaps, I can use ODBC as in Win32::ODBC to connect to a database file.
But
> how would I interact with a database without adding it to ODBC?
>
> Any advice on how do I go about .xls files?
>
>
> _______________________________________________
> Perl-Win32-Web mailing list
> [EMAIL PROTECTED]
> http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
