Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

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)


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..

Win32::ODBC is located here:

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:
> []
> 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