Link to home
Start Free TrialLog in
Avatar of FabRed
FabRed

asked on

Import data from XML file to database table.

Hi.
I am trying to learn how to use XML files (I have never worked with XML before!), and need some help. What I wish to do is to import customer-data from a XML-file (customer.xml, which is saved in my projects bin-folder in the Debug folder.) to my database table called customer.
When the user clicks on import customerdata the system is supposed to read the customer.xml file and save the customer information in the customer table. When the transfer is complete the system is to write a message to the user telling how many customers that was imported.
The customer table is like this:
firstname
lastname
address
postalcode
city
e-mail
telephone

Can someone pls help me with some code to accomplish this?!? I am using Visual Studio, visual basic and SQL Server.
ASKER CERTIFIED SOLUTION
Avatar of rdcpro
rdcpro
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial