Access MSSQL bulk Replacement database specified content code (1/3)

Modify through the Query Analyzer in the Access database tutorial (I'm using Access 2003 here)

1, open the Access database that you want to modify

2, in the Database "object" click "Query"

3. Click "Create query in Design view"

4, in the appearance of the interface to close the "Show table" small window

5, click the "View" menu, select "SQL View", the query window will appear, you can enter the SQL statement here

6, directly enter the following SQL statements:

Update table SET field =replace (field, "Original character", "replace character")

You can according to the actual situation, the above red Word can be replaced, here for example, suppose the table is Biao, the field content, the original character is www.111cn.net, the substitution character is down1.111cn.net, then the corresponding SQL statement is as follows:
Copy code code as follows:
Update Biao SET content=replace (content, "sh.111cn.net", "111cn.net")

Home 1 2 3 last