|
|
sybperl-l Archive
Up Prev Next
From: Eric Johanson <ERICJ at AMC-DIRECT dot COM>
Subject: RE: Perl to Access97
Date: Dec 8 1998 7:43PM
I'm not sure if this will help, but this is what I know:
you could just export the data into a delimited file, and then import into
access. (cake)
-or-
Get the ODBC module for Perl, create a ODBC source for the access database;
use that for direct, real time access to both Sybase, and Access Databases..
(not-so-cake)
Win32::ODBC is located here:
http://www.roth.net/odbc/
I hope this helps,
Eric Johanson
PS - oh, you could just create a ODBC source for the Sybase database, and
open it from access. 'duh'
> -----Original Message-----
> From: jrisley@nex-web4.corp.fedex.com
> [SMTP:jrisley@nex-web4.corp.fedex.com]
> Sent: Friday, December 04, 1998 1:41 PM
> To: SybPerl Discussion List
> Subject: Perl to Access97
>
> Situation:
>
> I'm collecting information from a LEGACY Application and am using SybPerl
> to
> push it into Sybase 11.5 on WinNT 4.0(SP3). But recently, I have been
> asked
> to to also push a copy of the collected data into an Access97 table.
>
> Has anybody used perl and Access97?
>
> Or, does anyone have a sample script to share so that I may learn by
> example?
>
> Thanks...
> Jason
|
