Question

Asked on 2006-01-06 at 17:13:27ID: 25032577

XML TO CURSOR

by: MJAVIERIII500

Rating7.6Very Good

Hi,

  I have a Mismo xml file that I wanted to convert into cursor so I can upload it to SQL, however, when I tried to run this:

    XMLTOCURSOR("myfile.xml","MYDATA",512)

  All I'm getting is a table with multiple rows of memo field. Which has no use for me because it's even worse than the actual XML file.  I need some reccomendation/suggestion on how I can easily convert the xml file to a much readable format ( meaning for validation and uploading purposes).

   Thanks in advance.

Related Solutions

Solution

Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution
Sign up Now to View This Solution
Zone
general
Tags
xml cursor
Participating Experts
2
Solution Grade
C

Replies

 by: CarlWarner

Posted on 2006-01-06 at 19:31:39ID: 26217250

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: suhashegde

Posted on 2006-01-06 at 21:43:07ID: 26217251

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: suhashegde

Posted on 2006-01-06 at 21:47:29ID: 26217252

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: MJAVIERIII

Posted on 2006-01-07 at 16:00:51ID: 26217253

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: suhashegde

Posted on 2006-01-07 at 22:35:16ID: 26217254

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Top Experts

  1. pcelba

    4,240

    0 points yesterday

    Profile
  2. mozner

    2,000

    0 points yesterday

    Profile
  3. mbarbir

    1,912

    0 points yesterday

    Profile
  4. jrbbldr

    1,500

    0 points yesterday

    Profile

BrowseAre you an Expert?