I agree with Larry. Leave ibatis out.
I have done it two ways in the past. The first is to export the table as a
csv and then use Oracle's Sqlldr to load the values into the new table.
The second is as Larry stated.
select 'insert into TableA (col1,col2,col3) values
('||col1||','||col2||','||col3||')' from oldTable;
You get the drift.
On 12/8/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
Hm, I wouldn't use iBATIS for this at all - Oracle has bulk data
loading tools that would do it WAY faster - if you can get the access
data ot to a file in the right format.
Heck, even generating a SQL script with a bunch of insert statements
would be faster.
Larry
On 12/8/06, Graeme J Sweeney <[EMAIL PROTECTED]> wrote:
> On Fri, 8 Dec 2006, puneet arya wrote:
>
> > you can use directly JDBC ....to insert data from access to database
> without using IBATIS
>
> For one table you're probably right.
>
> I use abator, if I have to do this type of a task.
>
> --
> Graeme -
>
