I have been given a database with 2,944 tables in it. Each table has
35 rows and columns labeled Dur, 20, 21, 22, 23, 24, 25, 26 ..... 64,
65. They contain insurance rates by age and band.
Currently all the tables are the same length and width. I need to go
through all 2,944 and delete out any colmn with a zero value. For
some that might be columns 64 and 65, for some 50 through 65, or any
other possible combination.
If I have to open 2,944 tables individually, I'll cry. Is there a way
to cycle through the tables and look for columns with a 0 value and
delete them with VB?
Thanks in advance,
Laura
|
