Clear Column in Table

[Lenny_821]

Hi All,

How can I clear the data from a specific Column within a Table?

Lets say; Table name is "Test", Column 1 is named "A" and Column 2 is named "B". And I only want the clear the data in column "B".

The record count I've got is over 130.000, so if there's a quick and easy way then I am all ears

Lenny

 

[KenHigg]

UPDATE test SET test.b = "";

???

 

[Summerwind]

I would use and ADODB command with the SQL string:

DELETE B FROM Test

 

[Lenny_821]

Do you have a more complete VBA code, because I am not so skilled with that.

Thanks.

Lenny

 

[KenHigg]

Dim strSQL As String
strSQL = "UPDATE test SET test.b = '';"
DoCmd.RunSQL strSQL


???

 

[Lenny_821]

Works Great

Thanks a milion.

Lenny

 

[KenHigg]

.
.
.
Cool!