Tags: access, ado, hiye, idea, net, oracle, transfer

Access to Oracle

On .Net » .Net ADO

2,405 words with 3 Comments; publish: Tue, 20 May 2008 13:00:00 GMT; (10078.13, « »)

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?

All Comments

Leave a comment...

  • 3 Comments
    • 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.

      "smen" <scht.net-ado.todaysummary.com.rocketmail.com> wrote in message

      news:045401c3c909$fe76e800$a501280a.net-ado.todaysummary.com.phx.gbl...

      > 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?

      >

      #1; Tue, 20 May 2008 13:02:00 GMT
    • 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?

      >--Original Message--

      >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.

      >"smen" <scht.net-ado.todaysummary.com.rocketmail.com> wrote in message

      >news:045401c3c909$fe76e800$a501280a.net-ado.todaysummary.com.phx.gbl...

      >> 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?

      >

      >.

      >

      #2; Tue, 20 May 2008 13:03:00 GMT
    • 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!

      **********************************************************************

      "smen" <scht.net-ado.todaysummary.com.rocketmail.com> wrote in message

      news:045401c3c909$fe76e800$a501280a.net-ado.todaysummary.com.phx.gbl...

      > 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?

      >

      #3; Tue, 20 May 2008 13:04:00 GMT