Update an account balance on a daily basis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carl.barrett@newcastle.gov.uk - 16 Dec 2005 12:55 GMT

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

Reply to this Message

Steve - 16 Dec 2005 14:32 GMT

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.

Reply to this Message

pietlinden@hotmail.com - 17 Dec 2005 04:12 GMT

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.

Reply to this Message