Importing a XML Infopath form into Access

G

Guest

I'm attempting to import a XML file into a new DB, however instead of 1
table, it is creating 3. The XML form contains rich text fields, which happen
to be the 2 additional tables being created in the import, I'm not sure if
this the reason.

I get the error message for the truncated fields.

Should I just create a table and change the data type to MEMO?
 
G

Guest

Solved it....

Access doesn't recognize rich text fields. I changed it to plain ol' text
and it loads with no problem....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing XML Data in Access 2003 1
changing the name of a table created by importing an XML document 1
XML into Access 2003 3
Importing XML File - Some Data Is Truncated 2
Problems Importing Govt. XML Files 1
Importing Multiple XML files into Access 2003 1
import csv truncation 1
Importing Project 2007 XML data into Access 2007 0

Top