Re: Import flat files to Access using PL/Sql

From: EscVector <Junk_at_webthere.com>
Date: 5 Dec 2006 11:44:17 -0800
Message-ID: <1165347857.579843.107050@f1g2000cwa.googlegroups.com>

sybrandb wrote:
> duane.d.dunn_at_boeing.com wrote:
> > 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.
>
> You want to replace a single-click task by pl/sql? You are aware pl/sql
> is an Oracle language?
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Use vbscript and OLEDB/ADO connection and recordset.

Very simple. No PL required.

If simple automation is required this is the way to go. Received on Tue Dec 05 2006 - 13:44:17 CST