XML Import Error: Too many fields defined.

[Srini]

Hi,

I am trying to import an xml file which has more than 255 fields.
Access is unable to import the xml file into tables and gives the error
message "Too many fields defined." in ImportErrors column.

I was wondering is there any solution to fix the problem.

Please reply.

Thanks in advance.

Srinivas

[MGFoster]

Srini wrote:

Hi,

I am trying to import an xml file which has more than 255 fields.
Access is unable to import the xml file into tables and gives the error
message "Too many fields defined." in ImportErrors column.

I was wondering is there any solution to fix the problem.

From the Access 2002 Help file article "About XML Data and Access":

"You can only import a single document at a time into Access. The data
must be in a format that Access recognizes, either in a native format or
through the use of a schema."

And,

"XSLT is a an XML-based language that allows one XML document to be
mapped, or transformed, into another XML document. This provides a way
of transforming an XML document's presentation information from a source
format to a target format and back again."

There is a pointer to this URL for info about XSLT:

http://search.microsoft.com/search/r...&c=0&s=1&swc=0

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)