Home » SQL & PL/SQL » SQL & PL/SQL » Export data to microsoft access
Export data to microsoft access [message #187563] Mon, 14 August 2006 08:22 Go to next message
prashantsorte
Messages: 2
Registered: August 2006
Location: India
Junior Member
Hi,
I want to export data from oracle database to MS access.
Data is specific meaning record by record I will have to update in the *.mdb file.
Front end is D2K.
Back end Oracle 9i.
Re: Export data to microsoft access [message #187719 is a reply to message #187563] Tue, 15 August 2006 02:52 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
More data please.
Are you trying to produce a file of data in a specific format, or a list or update/insert statements that you can run in Access.
Re: Export data to microsoft access [message #187722 is a reply to message #187563] Tue, 15 August 2006 02:55 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
On thing you could consider, would be to link from access into Oracle, File --> Get External Data --> Link Tables. This way, when data changes in the Oracle tables, the linked 'Access' tables will reflect those changes automatically. You can use Access pass-through queries to return results to get Oracle to do the actual processing of queries.

Jim
Re: Export data to microsoft access [message #187953 is a reply to message #187719] Wed, 16 August 2006 08:27 Go to previous messageGo to next message
prashantsorte
Messages: 2
Registered: August 2006
Location: India
Junior Member
I am feching some data from oracle data base and I want to store this data in the *.mdb file.
I am feching dat from different tables and columns and in same procedure I want to put it into *.mdb.
Re: Export data to microsoft access [message #187986 is a reply to message #187953] Wed, 16 August 2006 10:48 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If JSI2001's solution doesn't work for you, you may want to consider Connecting Oracle with MS-Access.
Previous Topic: Running sqlplus.exe as normal windows domain user
Next Topic: Loop Help
Goto Forum:
  


Current Time: Fri Dec 02 18:26:37 CST 2016

Total time taken to generate the page: 0.60937 seconds