By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,399 Members | 1,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,399 IT Pros & Developers. It's quick & easy.

XML Import Error: Too many fields defined.

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.