running a table creation script in access

[NITIN27]

Hi.
can a script be runned in microsoft access just as we do in oracle sql
eg. sqlplus
connect system/manager

@c:\all\alter.sql

This alter.sql has three tables creation script

I want to do same in Microsoft Acess

Thanks in advance.

 

[rdodge]

SELECT…INTO Statement (Make-Table Query)

Syntax

SELECT <Field1>[, <Field2>[, ...]] INTO <Table> [IN <ExternalDatabase>]
FROM <Source>

The Select Clause in this type of query follows the same rule as the Select Clause in the Select Query, but in addition, put the following line immediately after the selection of the fields:

INTO <Table>

<Table> is the name of the new table in String Data Type.

If the table is to be in an external database, you can use the IN Clause.

Select…INTO Statement has the following rules that is different from the Select Statement:
• There is no predicate
• Target must be a table that does NOT exist at the time the query is triggered
• newly created table is populated by the query


Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.