我有一個問題先~~~~~~~~~~~~

[bubblebird]

我用PowerDesign生成了一個sql文件（test.sql），如下
#==============================================================
# Database name: PhysicalDataModel_2
# DBMS name: Microsoft Access 2000
# Created on: 2002-10-17 13:45:54
#==============================================================
RemoveTble C=Table_1;
#==============================================================
# Table : Table_1
#==============================================================
CreateTble C=Table_1 N="Table_1"
(
C=Column_1 T=TEXT(10) P=No M=No N="Column_1",
C=Column_2 T=TEXT(10) P=No M=No N="Column_2",
C=Column_3 T=TEXT(10) P=No M=No N="Column_3",
C=Column_4 T=TEXT(10) P=No M=No N="Column_4"
);
在Access中怎樣才能轉化成Table???

[奇遇]

U can use Ctr+G in PD, u not choose Radiobutton gerneric script... but odbc... ,then U select a access's dsn and u can get a script as:

/*==============================================================*/
/* Database name: PhysicalDataModel_1 */
/* DBMS name: Microsoft Access 95 & 97 */
/* Created on: 2002-10-21 13:40:11 */
/*==============================================================*/


drop table Table_1;

/*==============================================================*/
/* Table: Table_1 */
/*==============================================================*/
create table Table_1
(
Column_1 TEXT(10),
Column_2 TEXT(10),
Column_3 TEXT(10),
Column_4 TEXT(10)
);


Following , U take it into a view design (SQL VIEW Design) and execute it , that's OK! :)