Importing XML File - Some Data Is Truncated

[JaysonWard]

I'm importing an XML file into an Access data base. One of the xml
tags that will be imported as a column of data typically has more than
255 characters.

When I import the XML into Access, it creates a table with Fields all
set to Text, which only allows 255 characters.

Is there a way to specify what you want the data type to be for each
thing when importing into Access.

The text data type works fine for all of the other columns, but I need
a memo data type for the wordy one.

Thanks for your help.

Jayson

 

[JaysonWard]

For those who have the same issue, I discovered the answer that fit my
needs so I thought I would reply to my own add.

The solution is to use some simple VB to append the xml file to a table
with already defined data types within your database.

The article is located at:

http://www.microsoft.com/technet/scriptcenter/resources/officetips/oct05/tips1020.mspx

Hope this helps.

Jayson