XML Import problem

[chisaidj]

I would greatly appreciate any help on this; it's driving me mad!

I'm using Access 2003 to import an XML file. The data is fine in original
XML document but one of the fields is always truncated to 255 characters when
imported.

I am amending to an existing table which has the particular data field set
to memo so I really don't understand why this is happening.

Any help appreciated

Thanks in advance

 

[Stefan Hoffmann]

hi,

I'm using Access 2003 to import an XML file. The data is fine in original
XML document but one of the fields is always truncated to 255 characters when
imported.

How do you import it? What kind of structure does your XML file have?
What data type has your field your loading the data in?



mfG
--> stefan <--

 

[chisaidj]

Hi Stephan,

Thanks for your reply.

I'm using the Access 2003 "get external data" > "Import" function and
choosing "Append to Existing Table"

The XML has a simple structure e.g.:

<ReportItem><ReportName>09/01/30 03:39:47 PM - Default scan
policy</ReportName><HostName>212.240.88.100</HostName><port>general/udp</port><severity>1</severity><pluginID>10287</pluginID><pluginName>Traceroute</pluginName><data>For
your information, here is the traceroute from 195.188.x.y to 212.240.a.b :
80.193.208.161
62.30.251.201
195.182.178.90
212.43.162.198
Truncated
</data></ReportItem>

Everything imports fine into text fields in a single table except from the
'data' element which gets truncated to 255 regardless of the fact that it is
being imported into a memo field.

Very new to this so aplogies if I'm making a stupid mistake but help is much
appreciated.

Many thanks

 

[Stefan Hoffmann]

hi,

<ReportItem><ReportName>09/01/30 03:39:47 PM - Default scan
policy</ReportName><HostName>212.240.88.100</HostName><port>general/udp</port><severity>1</severity><pluginID>10287</pluginID><pluginName>Traceroute</pluginName><data>For
your information, here is the traceroute from 195.188.x.y to 212.240.a.b :
80.193.208.161
62.30.251.201
195.182.178.90
212.43.162.198
Truncated
</data></ReportItem>

Everything imports fine into text fields in a single table except from the
'data' element which gets truncated to 255 regardless of the fact that it is
being imported into a memo field.

This works for me. Check the data in your "data" field. Press F2 when
you set the focus in it, I assume you only see "For" in the tabular
view, because the data element contains a line break.



mfG
--> stefan <--