create a table within an access2007 database using code in a vb.net app ?

[Aussie Rules]

Hi,

Is it possible to create a table via code (create table ........) in an
access 2007 database from a Vb.net 2008 application?

Any tips/samples/links on how to do this ?

 

[Allen Browne]

Assuming you have some kind of driver that connects to the Access database,
you can execute a DDL query to CREATE TABLE.

Here's an example of executing a DDL statement to create a table:
http://allenbrowne.com/func-DDL.html#CreateTableDDL
The example is VBA code, but the SQL statement would be similar in whatever
language and connection you use from VB.NET.