Creating Access Table in VB.Net

[rickb]

Here's what I've got : I have a button which, when clicked, needs to create a new table in an existing database. The name of the new table comes from a label text property, which gets its value from a combobox selection. Here's the code where my problem exists:

 

Dim oledbcon as New oledb.oledbconnection=("Provider=Microsoft.Jet.OLEDB.4.0; Data Source= <path to db>")

oledbcon.open

 

Dim oledbcom as New oledb.oledbcommand=("CREATE TABLE" & lblinstructor.text & "(Col1 Text, <plus more columns>)",oledbcon)

Debug.WriteLine(oledbcom.ExecuteNonQuery())

 

The error shows up at the last line ("Debug. . . ).

 

This works perfectly if the table name is a static name, but that's not what I need.

 

Can someone show me, or point me in the right direction, for creating a new table who's name is dynamic? Thanks in advance.

[Nerseus]

You need a space between TABLE and the name of the table. Right now, the double quote is next to the word TABLE. Try this instead:

Dim oledbcom as New oledb.oledbcommand=("CREATE TABLE " & lblinstructor.text &...

 

-Ner

[rickb]

Thank you very much for the reply; it worked perfectly! You have saved my sanity.

[bungpeng]

Is it possible to create/delete Database in VB.NET? or any other way to do it?