yes, sure, you can either run SQL DDL statement, like ater table add column
or use DAO - create tabledef object, and use it .fields.add method. Both samples you can find in online help
sarah wrote 22/04/2009 :
is there a way for me to insert a column to a table through VB code? i am importing data from excel and want to append a column to the end of the data and need the whole process automated
To answer please click on Q or A sign on the left of the subject.
Written and designed by
Send us your comments
Copyright © 1998-2007 by MAUG