"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
