Forum home » Delegate support and help forum » Microsoft Access Training and help » Replacing data

Replacing data

ResolvedVersion 2003

Fri 13 Nov 2009, 10:44 Delegate 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:18 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Replacing data

Replacing data

RE: replacing data

Access articles

Access tip:

Hiding Multiple Table columns