Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Transfer data from XML to Oracle9i

Posted on 2004-10-05
7
Medium Priority
?
178 Views
Last Modified: 2010-08-05
I have exported employee table data rom MSAccess2000 to XML by XMLWrite in VB.NET.
Now I have the same table in Oracle9i database. I want to transfer the data from XML to Oracle 9i employee table. I want to know code in VB.NET. I am using Visual Studio 2002.
0
Comment
Question by:saurabh_pradhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 5

Expert Comment

by:thenrich
ID: 12229160
Do you want to append to an existing table or create a new table?
0
 

Author Comment

by:saurabh_pradhan
ID: 12235228
I want to append to an existing table.
If that is not possible then I can create a new temporary table and the transfer the data to the original table. But the application preference is to append data to existing table
0
 
LVL 10

Accepted Solution

by:
123654789987 earned 1000 total points
ID: 12235768
0
 
LVL 6

Expert Comment

by:zulu_11
ID: 12247074
post your xml .. i can then give u a starting code snippet..on how to insert the values..in the table
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question