Hello, would anyone happen know how to add a new table to a MS Access database? I have a few text boxes set up along with a button, I want the user to be able to fill the text boxes and click the button and have an entirely new table be created using the data the user inputted. Any ideas on how to start this?
Thank you.
Mike GoldPosted Aug 19, 2007, 12:36 AM
you can try this, although I'm not sure if it works with Access or not:
OleDbCommand CreateTable = new OleDbCommand ("Create Table a1(vno integer,name char(20))", connection);
CreateTable.ExecuteNonQuery();