Importing a XML Infopath form into Access

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Solved it....

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