Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 extract data from multiple oracle tables

Author  Topic 

helpme
Posting Yak Master

141 Posts

Posted - 2007-01-12 : 09:20:37
I know very little about access, so i would like to have some guidance on the best way to do what one of our users would like to do.

We have a user that wants to pull data from multiple oracle tables and import the data into an access database on a regular basis (maybe daily). I think the oracle tables have the same key, so joining them should not be too difficult. I'm just not sure what the best approach to setting something like this up would be.

Any help would be appreciated.

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-01-12 : 10:15:07
dunno....but it might be best answered on an oracle supportive forum....like www.dbforums.com
Go to Top of Page

helpme
Posting Yak Master

141 Posts

Posted - 2007-01-12 : 14:59:28
We are wanting to do this from within MS access, but thanks for the suggestion.
Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-01-15 : 06:17:42
I've never seen an "Access to/from Oracle" problem posted here. We have little enough (stated) knowledge in Access so adding Oracle into the equation may push this post to a dead-end. Going to an Oracle forum might give you a better lead.
Go to Top of Page
   

- Advertisement -