Field missing upon XML import

P

Phil Hellmuth

I'm attempting to import an XML file into an Access table. However, if
a field name doesn't appear in the first handful of records (not sure of
the breaking point), any subsequent instances of the field that may
appear later in the file is not imported. For example, let's say
there's a field called 'FieldX', but there's no FieldX value (nor tags)
for the first 100 rows, but there is in row #101. The result is FieldX
is NOT imported. Is this a known issue? Is there a workaround?
 
J

Joe Fawcett

Phil

How are you setting up the import initially. Unless Access has a schema to
work from then it will infer one using the first few rows. If your record
isn't there then it will not be created later.
 
Top