Re: Converting Oracle 7 dbs into MS Access 2K

From: Danny J. Lesandrini <dlesandrini_at_hotmail.com>
Date: Tue, 16 Oct 2001 14:44:44 -0600
Message-ID: <9qi684$o11v3$1@ID-82595.news.dfncis.de>

What prevents you from simply importing the data into Access 2k via odbc linked tables. Create your links and then do this:

SELECT dbo_OracleReport.*
INTO tblLocalReport
FROM dbo_OracleReport;

You will need to tweak some datatypes, but it's worth a try.

--

Danny J. Lesandrini
dlesandrini_at_hotmail.com
http://datafast.cjb.net


"rtdos_at_yahoo.com" <rtdos_at_hotmail.com> ...


> Can anyone direct me to a site that explains converting an Oracle 7 dbs (on

> a UNIXWARE box) into Microsoft Access 2K database using ODBC ?

>

> --

> J.Wood

> rtdos_at_juno.com

>

>

Received on Tue Oct 16 2001 - 15:44:44 CDT