How to create a table by code

  • Thread starter Tor Inge Rislaa
  • 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
 
C

CSmith

Hi,

Here's an SQL example:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Storing a query in an existing database 2
create a table within an access2007 database using code in a vb.net app ? 1
CREATE TABLE... 3
Help on QBE to SQL 1
Create a table with code 2
Delete whole table with SQL and ADO 1
How to use the results from a runing total query to update a table 1
Make-table query with around 2 ml records taking too long 0

Top