Creating DataTable Access

Question

Is there a way I can create a datatable in Access at runtime? There will be many tables and I can't create them myself. If not what other programs support this?

johnbill2004 · Answer

I think this piece of codes can help you: string myConnString = Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Data Source=My.mdb; OleDbConnection conn = new OleDbConnection(myConnString); conn.Open(); OleDbCommand command = new OleDbCommand(CREATE TABLE TEST_TABLE (ID INT) conn); command.ExecuteNonQuery(); command.Dispose(); conn.Close();