- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: MS Access database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 04:26 AM
тАО10-20-2005 04:26 AM
MS Access database
I need to move data from oracle table to MS Access table. I dont want to do an import , cos it creates a new table in MS Access.
I have the empty structure (exact) of Oracle table in MS Access database. I need only the data to be pulled from oracle and insert it into MS Access table.
Any provision in MS Access?
Hope i'm clear.
~Jil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 04:29 AM
тАО10-20-2005 04:29 AM
Re: MS Access database
and then create your Oracle link into the Access database. Then create an insert query in Access, selecting from the Oracle tables, and inserting into the access (local ones).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 04:43 AM
тАО10-20-2005 04:43 AM
Re: MS Access database
~Jil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 04:55 AM
тАО10-20-2005 04:55 AM
Re: MS Access database
you can use SQL script to generate a "dump" for each table.
The output format is character with a separator.
I've done the other way around (MS Access to Oracle) and the script generates the CTL file too.
interested ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 04:59 AM
тАО10-20-2005 04:59 AM
Re: MS Access database
Yes, you'd have to repeat it 200 times, if you want the links to show up.
You can use the ODBC connection directly and from VB(within Access) open up a pass-through query right into Oracle, and skip the Link process. But, you will have traded that for a coding process in which you'd have to specify the 200 tables via code segments instead of clicking around. Might be better, might not...
There is a product called DataJunction which could probably assist you on this. I know groups here use that for moving data in and out of Oracle, Access, and SQLServer. I'm not familiar with it myself however.
Regardless of method, I'm pretty sure you're going to have actually specify what tables you want to pull from individually, and not a whole schema - much less a database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 06:04 PM
тАО10-20-2005 06:04 PM
Re: MS Access database
Did you try the "Append data to existing tables" option when using the IMPORT option?
It works for me!
This is what i did:
1. Export data from Oracle table to xml format
2. Run MS access open MS access Database
3. File -> Get External Data -> Import ->
then on the imprt XML window, click options, then "Import OPtions" = "Append Data to Existing table(s)"
hope this helps too!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-21-2005 02:06 AM
тАО10-21-2005 02:06 AM
Re: MS Access database
I had created a macro with "button" to launch my import using the filter, it imported only the records I required and was fairly simple to setup.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-21-2005 03:25 AM
тАО10-21-2005 03:25 AM