VB "Make Table"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James C. - 15 Jul 2005 22:46 GMT

Does anyone know how to do a make table using vb? I am running SQL in one of
my functions and need to create a table.

Reply to this Message

Joerg Ackermann - 16 Jul 2005 00:17 GMT

> Does anyone know how to do a make table using vb? I am running SQL in
> one of my functions and need to create a table.

use (DDL) SQL -> currentdb.execute "CREATE TABLE...
or
use VBA -> CreateTabledef-Method

There are several examples in access-help

Acki

Reply to this Message

Carol Grismore - 16 Sep 2005 17:13 GMT

dim mySQL as string
mySQL = "create table Fred (txtText char(50), datDate datetime, intInt int)"
docmd.runsql mySQL

If you want to make a table from existing data, replace the mySQL text with
text stolen from a make table query.

Signature

Carol

> Does anyone know how to do a make table using vb? I am running SQL in one of
> my functions and need to create a table.

Reply to this Message