Update an account balance on a daily basis

[carl.barrett]

I have a text file that needs to be imported into a table on a daily
basis.
The data is replaced each day except for one field.
This field has an account balance in it and needs to be added to each
day so that it increments.

What will be the bext way to do this.

Regards.

Caba

[Steve]

You may want to investigate the DoCmd.TransferDatabase command in
Access Help. You can extract the original account balance from the
existing data, store it in a variable, read the text file into that
same original table, and then replace the account balance field's value
with it's value plus the original account balance value you stored
earlier.

[pietlinden]

Of course, if the data is normalized, he can run the import as you
suggest, and then use a single update query. Maybe wrapping the whole
thing in a transaction might be a good idea, because otherwise, he
could have a partially successful run of the procedure, and it would
invalidate his data.