Add column to a table

  • Thread starter Thread starter Guest
  • Start date Start date
Is it possible to add a column to an existing table using VBA?
Click to expand...

Yes; it's not the simplest way but it can be done. Use the CreateField
method of the DAO TableDef object - see the VBA online help for
details.

John W. Vinson[MVP]
 
Thanks, John...After some more research I figured out what key words I needed
to search for help and found a posting that that helped.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Add column with data to an existing table 8
Turning a 3 column flat file into a "3D" Table 2
How can I change the column order using VBA 5
Adding Data to a lookup column in a form 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
ALTER Table Add Column...y/n? 2
Alter Table/Column to RTF 6

Back
Top