Loading

Creating DataTable Access

onez

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

johnbill200422y ago
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();