How to create a table by code

  • Thread starter Thread starter Tor Inge Rislaa
  • Start date Start date
T

Tor Inge Rislaa

How to create a table by code

Hi, I have a VB.NET application running against an Access database. I
communicate with the database trough an ADO connection. Today I perform all
sorts of query against the database, but I need a query to create a new
table in an existing database. Is that possible? If anyone have an example
code? (what I am looking for is the SQL statement)

TIRislaa
 
Hi,

Here's an SQL example:

Create Table tblMyNewTable (FirstName TEXT, LastName TEXT, Salary DOUBLE)
 
Back
Top