Results 1 to 3 of 3
  1. #1
    pb45102 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011

    XML Parsing Error

    I have upgraded from MS Access 2007, to MS Access 2010 (64bit). I have a query that parses some data as follows:

    I&C AC: IIf([FC2]>50000,Left([Activity Category],1) & "b",[Activity Category]).

    When creating a Pivot table or a Pivot chart based on this query, I get the following error:
    XML parsing failed at line 1, column #, Semicolon expected.. The following system error occurred:. XML parsing failed at line one, column #: The name in the end tag of the element must match the element type in the start tag..

    The pivot tables work fine in the 2007 version, but seem to break in the 2010 version. Does anyone have any ideas of why this is a problem or how to fix the problem?

    Any assistance is appreciated.


  2. #2
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    hmmm...advanced question. start here:

    as you can see from the results, it probably doesn't happen often, as this page is the first answer from google's math.

    Tell us if you get any useful info there.

  3. #3
    Vince is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2011

    Parsing failed at line 1

    Hi there,
    I do have the same problem than pb45102. I use Access 2010 32 bits. Have you solved this problem? I've been stuck with that issue for several weeks now.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access front end for parsing xml string
    By raghu_nandan1 in forum Programming
    Replies: 0
    Last Post: 04-21-2011, 07:58 PM
  2. Parsing A Comma Delimited Field
    By AccessGeek in forum Import/Export Data
    Replies: 6
    Last Post: 02-03-2011, 01:52 PM
  3. Parsing for data in between two characters
    By rawdata in forum Access
    Replies: 7
    Last Post: 11-02-2009, 04:46 AM
  4. Parsing data into something usable.
    By crownedzero in forum Import/Export Data
    Replies: 22
    Last Post: 08-05-2009, 07:18 AM
  5. parsing data in access (coding?)
    By banker247 in forum Programming
    Replies: 0
    Last Post: 01-13-2009, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums