RE: Help Oracle to Access

I love this idea. I use DTS all the time but didn't know I could use it to move Oracle to access. DTS is such a great tool!

-----Original Message-----
From: Grant Allen [mailto:Grant.Allen_at_towersoft.com.au] Sent: Friday, August 26, 2005 1:21 AM
To: Stankus, Paula G
Cc: oracle-l_at_freelists.org
Subject: RE: Help Oracle to Access

-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
>Paula_Stankus_at_doh.state.fl.us
>Subject: re: Help Oracle to Access
>
>I know it seems backward but I got a request to move Oracle database
to access. What is the easiest way to do this?

Paula,

I know you also have DTS available from you SQL Server side of life. I've used it with some success in the past to move data from Oracle into Access/Jet. Just check the datatype mappings and you should be fine (e.g. only 32-bit integers in Jet, small varchar limit, etc.)

Ciao
Fuzzy
:-)

--
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 42411473) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=s&i=42411473&m=94ceca2ad
88e
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=n&i=42411473&m=94ceca2ad
88e
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=f&i=42411473&m=94ceca2ad
88e
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
http://www.freelists.org/webpage/oracle-l