Solved

Transfer data from XML to Oracle9i

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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

734 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