Solved

Transfer data from XML to Oracle9i

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
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 …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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