Access to Oracle

[smen]

hiye, i have got some data in ms access and i want to
transfer all the data into oracle. any idea how to get it
done?

 

[William Ryan]

There are a few ways, but using Oracle's SQL Loader is probably one of the
easier ways. Are you looking to do it through code or do you know Oracle at
all? You can do it through ADO.NET, but it's not the preferred way. You
could also Export the Access files and do a straight import to Oracle, but
you won't preserve schema information if you do it that way.

 

[Guest]

thanks for the reply. i'm very new to oracle and i cant
seem to find the oracle sql loader.

i plan to do it using ado.net and store the access data
in a dataset and use that dataset to merge it with oracle.

can that be done?

 

[Cowboy \(Gregory A. Beamer\)]

If you have access to SQL Server (or Client Tools), you can use the
Import/Export feature, which uses DTS. If not, check William Ryan's answer.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************