98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Replacing data
Replacing data
Resolved · Urgent Priority · Version 2003
Fri 13 Nov 2009, 10:44Delegate Xing said...
Xing has attended:
Access Introduction course
Access Intermediate course
Replacing data
Hi,
In my database, I need to replace a huge amount of data in one field. I wonder if there is a quicker way to replace them all, e.g. using a query?
Thanks. Looking forward to your reply.
Regards,
Xing
Tue 17 Nov 2009, 09:18Trainer Stephen said...
RE: replacing data
Hi Xing
Thanks for your question
The quickest method would be to use an update query which can be used to replace specified data within a given recordset.
Can you clarify the following for me so I can be more precise
1. Does the new data exist in some electronic form (database or
spreadsheet)
2. Is the data to be replaced in 1 or multiple tables
Thanks
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
