Re: How to Oracle data --> Microsoft Access (mdb) or txt files

From: <mikebyrne_at_my-deja.com>
Date: 2000/07/15
Message-ID: <8kq91d$h27$1@nnrp1.deja.com>#1/1

We do this entirely from the client side (Access) using VBA and queries. Obviously you could alternatively write a program that creates text output on the server side and use Access and VBA to import the text. Tricky part is making it robust.

In article <kq2vmso7ub6m4sun6rva42d8gt298f3r6c_at_4ax.com>,   npi_at_inet.net wrote:
> On Fri, 14 Jul 2000 07:15:22 +0200, npi_at_inet.net wrote:
>
> >
> >Hi
> >
> >How to 'extract' the data from a Oracle database for create a new
> >database with Microsoft Access.
> >
> >Any idea?
> >
> >Thanks.
>
> ----------------------------------------------------------------------

---

>
> Sorry, but the process (batch) Oracle --> Acces must be every nights
> for sync both databases.
>
> The file or files generates by the process could be .txt .xls or .mdb
>
> (the server is NT, not UNIX)
>
> Thanks for your comments.
>
>

--
Mike Byrne
Charlotte, NC


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Sat Jul 15 2000 - 00:00:00 CDT