Solved

Transfer data from XML to Oracle9i

Posted on 2004-10-05
7
170 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
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 250 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

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 …
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now