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

  • Thread starter Thread starter Aussie Rules
  • Start date Start date
A

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 ?
 
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.
 
Back
Top