By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
er**********@hotmail.com (Eric) wrote in message news:<53************************@posting.google.co m>...
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


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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.