Importing XML File - Some Data Is Truncated "JaysonWard" <jaysonnward[ at ]yahoo.com> 13.07.2006 20:11:10 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

Re: Importing XML File - Some Data Is Truncated "JaysonWard" <jaysonnward[ at ]yahoo.com> 13.07.2006 22:42:01 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 JaysonWard wrote: [Quoted Text] > 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