Update XML File

[Doug Bell]

Hi I have an application where I need to Update an XML file.

The source is an Access DB.

The Application imports new records from the Access DB into a DataSet and
then needs to update the XML File.

The problem I have is that WriteXML overwrites the existing XML file so on
subsequent run only records that are new since the previous run will be in
the XML file.

I thought I could over come this by first reading the XML File into a
DataSet and then appending the new records from the DataTable of New Access
DB records into the DataTable of existing XML records.

However the only way I know of doing this is to itterate the rows of
dtAccess, creating a new row (rowNew) in dtXML and setting the value of each
field in rowNew to the Column value for each corresponding field in the
current row of dtAccess.

Is this the only solution or is there a way I can append a new row to dtXML
by copying the entire row from dtAccess?

Or is there a way of appending rows to the XML file?

Thanks

Doug

[Axel Dahmen]

> Is this the only solution or is there a way I can append a new row to
dtXML

by copying the entire row from dtAccess?

Or is there a way of appending rows to the XML file?

Hi, Dough,

try:

DataTable.Rows.Add(...)

HTH,
Axel Dahmen
www.sportboatcharter.com

[Doug Bell]

Thanks Axel,
I have solved it using

For Each dr In dtTrans.Rows 'Import rows from dtTrans into dsExtract

dsExtract.Tables(stTransTbl).ImportRow(dr)

Next ' Each dr In .Rows
"Axel Dahmen" <NO*****@NoOneKnows.invalid> wrote in message
news:Os**************@TK2MSFTNGP14.phx.gbl...

Is this the only solution or is there a way I can append a new row to

dtXML

by copying the entire row from dtAccess?

Or is there a way of appending rows to the XML file?

Hi, Dough,

try:

DataTable.Rows.Add(...)

HTH,
Axel Dahmen
www.sportboatcharter.com