Extract a sql field containing xml to a new sql database tabel
$30-250 USD
Completed
Posted almost 11 years ago
$30-250 USD
Paid on delivery
I have a sql table that has one field containing data in an xml format.I need to export that xml data into their own fields. I would like to be able to import the extracted data into a new sql table. If you provide me a text file I can do the import.I have attached a sample of the data to to be extracted.
10716
Smith
Joe
1280 main AVE.
GILROY
CA
5
95020
UNITED STATES
en-US
558-848-5571
.
This is a very simple project I am more than qualified to do the job and ready to start now. I can add all the required info to a new csv file.
Hope I get a chance to offer you my skills.
Thank You
Good evening, I have read over your job and worked with your sample data. I created a file pipe delimited that you should easily be able to import into any sql table. There doesn't seem to be a way to attach the file though so here is the first two lines.
1024572|-1|DAVID R|TILLER|102457264495851|291 SOUTHRIDGE DRIVE|BLOUNTVILLE|TN|43|37617|UNITED STATES|en-US|423 323-4550
1048304|-1|JAN MORTEN|FINSRUD|104830405242647|VESTRE �SLUND 74|DR�BAK|92|1440|NORWAY|nb-NO|+47 9707024
Please consider me for this job. Thanks.
Dear Customer,Greetings:):) We will be highly obliged to get an opportunity to work for you. My reviews on freelancer.com speaks about my credibility. I would love to start right away and can assure outstanding quality delivery in a timely fashion. An exciting proposal is waiting for you in your Inbox here. Please manage some time to check the Inbox for our samples & bid details.
Regards,
Crispy
6 years of professional expertise in software development sector in .NET platform using C#, ASP.NET,WPF, Silverlight, SQL Server, HTML, CSS, JavaScript, JQuery etc.
Hello, I've already completed your task. Please check PM for demo.
I'm an expert C# developer, I've a great deal of experience with SQL Queries involving XML data.