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: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 06 Dec 2006 23:13:37 GMT
Message-ID: <B8Idh.30268$hn.29723@edtnps82>


"klabu" <klabu76_at_gmail.com> wrote in message news:12neg0fk6asi151_at_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
>
>

You could possibly define an Heterogeneous Service (using ODBC/OLEDB) which would allow you to access the MSAccess database straight from within your PL/SQL procedure.
It would require that the mdb file is located on the database server.

-- 
Terry Dykstra 
Received on Wed Dec 06 2006 - 17:13:37 CST

Original text of this message

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