What you can do is copy a blank database (or nearly blank if you build the
structure of the table that is going to receive the data into this template
database), then reference the copied database using a DSNless connection to
that file with OLE and then populate the table in that database with the
records extracted from the Oracle database.
pseudo-code :
`cp basiclocation/file.mdb, newlocation/file.mdb`;
rename("newlocation/file.mdb", "newlocation/oracle.mdb");
use OLE;
get the data from Oracle;
insert the data into newlocation/oracle.mdb;
You can open two database connections at the same time: one to SELECT from
the Oracle db referenced by a DSN and one to INSERT into the Access db
referenced via the file name. That way the data doesn't have to get stored.
Copying gives you a clean copy of the database to start from every time and
will only use one or two modules (OLE and possibly ODBC), meaning that it
can be deployed on different machines without requiring the installation of
a lot of modules.
- Mike DeWolfe
----- Original Message -----
From: "Morse, Richard E." <[EMAIL PROTECTED]>
To: "'Mike DeWolfe'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 9:02 AM
Subject: RE: MSAccess file format question...
> Hmmmm... however, I don't need to just create a blank database -- the idea
> is to be able to have a cgi extract data from an Oracle database and
create
> an Access database with the data in it, and then return that via HTTP
> download... In order to do that, I need to be able to write out to the
> Access file format...
>
> Thanks for any help,
> Ricky
>
> -----Original Message-----
> From: Mike DeWolfe [mailto:[EMAIL PROTECTED]]
> Sent: Thursday 28 February 2002 11:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MSAccess file format question...
>
>
> What I've done in the past is make a blank database and then copy that
file
> and rename it as required. As it's only a file (and a small one when it's
> empty), that makes it easy to throw around.
>
> - Mike DeWolfe
>
> ----- Original Message -----
> From: "Morse, Richard E." <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 28, 2002 7:42 AM
> Subject: MSAccess file format question...
>
>
> > Hi! For a particular application (actually, a CGI) I am writing, I want
> to
> > be able to create a .mdb (access 2000 version) file. However, if
> possible,
> > I want to avoid actually opening access. Is there some reference that
> would
> > tell me what the Access2000 file format is? Or, better yet, is there a
> > module somewhere that will do this?
> >
> > Thanks,
> > Ricky
> >
> > -----------------------------------------------------
> > Richard Morse System Administrator
> > MGH Biostatistics Center 50 Staniford St. Rm 560
> > [EMAIL PROTECTED] 617/724-9830
> > _______________________________________________
> > Perl-Win32-Users mailing list
> > [EMAIL PROTECTED]
> > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
> >
>
> _______________________________________________
> Perl-Win32-Users mailing list
> [EMAIL PROTECTED]
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
>
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
