Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import flat files to Access using PL/Sql

Re: Import flat files to Access using PL/Sql

From: klabu <klabu76_at_gmail.com>
Date: Wed, 6 Dec 2006 17:11:26 -0500
Message-ID: <12neg0fk6asi151@corp.supernews.com>

<duane.d.dunn_at_boeing.com>

>I have a task that I would like to automate. The task involves

> Importing a *.csv file to an Access Database using pl/Sql. Does anybody
> out there have sample code for this.

Is the CSV just "sitting there" waiting to get imported into Access ? or you need to invoke PL/SQL stored proc to kick it off ??? Assuming you start with NOTHING,
what I did before was:

VBA on Access/Excel --> Call PL/SQL Oracle via OO4O/OLEDB/ADO/etc ---> Oracle outputs the file to an acceesible location VBA read & import the file Received on Wed Dec 06 2006 - 16:11:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US