Re: Oracle to Access

[Scott Eubank <SEUBANK@ADVANCEAUTOPARTS.COM>]

 You have several options.
  1) create a CSV file  and import into ACCESS
  2) create an ODBC connect to access from the SQR and write directly to it
  3) create an Append query in Access and do it in Access

  I love access and would choose 3 as it would be the easiest option for me.
Could proabably do it in an hour if it wasnt a complex append query.
Otherwise you have to create a connect from the SQR to Access and then do
the up append.

  AND NO you CAN'T create an Access TABLE out side of the JET database
engine. Which is the data base engine that powers Access.  Microsoft did
something right when they created Access.  It's easy to develop in , fairly
powerful , and makes nice front ends.

Good Luck



-----Original Message-----
From: Duncan Hudson [mailto:dhudson@DYNAX.COM]
Sent: Wednesday, December 12, 2001 9:57 AM
To: SQR-USERS@list.iex.net
Subject: Oracle to Access


I have an interface requirement that has me reading from an Oracle database
and then writing the results to an Access database.  Ideally, I'd like to
actually create the Access file, but I'll settle for just appending rows to
it - as I haven't been able to find anything about creating Access files in
any language.  My question is can I do this in one job (reading from Oracle,
and writing to Access), or am I going to be forced to break this up into
multiple steps.  Anyone have any thoughts?  Thanks in advance,


Duncan Hudson