VBA to add a colum to a table and then modify the data type

Hello,
I have a Existing table with three columns that have a data type of
string. I want to write VBA code that will modify one of the colums to
DataType of Number.

Also, I'm looking for code to add a column to the table.

ANy suggestions would be appreciated.

Thanks

Eric

re: VBA to add a colum to a table and then modify the data type

ericlangland@hotmail.com (Eric) wrote in message news:<5372437.0401191420.e5b120d@posting.google.co m>...[color=blue]
> Hello,
> I have a Existing table with three columns that have a data type of
> string. I want to write VBA code that will modify one of the colums to
> DataType of Number.
>
> Also, I'm looking for code to add a column to the table.
>
> ANy suggestions would be appreciated.
>
> Thanks
>
> Eric[/color]

Hmm... modifying the databse on the fly? Yes, you can do it. But for
the most part, why?
Have a look at the Columns collection of the ADO table object or the
DAO Fields collection of the tabledef object in the help.