writing a script

  • Thread starter Thread starter brokerluke
  • Start date Start date
B

brokerluke

how would i write a script that i can change as needed
that will do
find "test"
replace all "test" with a blank field or deleting it.
just like you would use the find button by clicking and typing in the info..
i'm looking for automation

i have to do this manually now and its very painstaking as i have to do this
5-6 times every time i import data..

what would do macro?.. VB script look like for such a task?
 
how would i write a script that i can change as needed
that will do
find "test"
replace all "test" with a blank field or deleting it.  
just like you would use the find button by clicking and typing in the info..
i'm looking for automation

i have to do this manually now and its very painstaking as i have to do this
5-6 times every time i import data..

what would do macro?.. VB script look like for such a task?
Click to expand...

use an update query

UPDATE MyTable
SET MyField=Null
WHERE MyField = 'Test';

If you had to do a bunch of them, use

DBEngine(0)(0).Execute "UPDATE MyTable SET MyField=Null WHERE MyField
= 'Test';", dbFailOnError
DBEngine(0)(0).Execute sqlStatement2
DBEngine(0)(0).Execute sqlStatement3
 
Back
Top