sql语句 建立access数据表

在sql中，   我用下边的语句就可以建立数据库，我现在想用这些语句，在access中建一个这样的数据表，就是这个意思！  
   
  CREATE   TABLE   FirewallLog   (  
  [ClientIP] varchar(32),  
  [ClientUserName] varchar(32),  
  [ClientAgent] varchar(128),  
  [ClientAuthenticate] varchar(5),  
  [logDate] datetime,  
  [logTime] datetime,  
  [service] varchar(12),  
  [servername] nvarchar(32),  
  [referredserver] varchar(32),  
  [DestHost] varchar(255),  
  [DestHostIP] varchar(32),  
  [DestHostPort] int,  
  [processingtime] int,  
  [bytessent] float,  
  [bytesrecvd] float,  
  [protocol] varchar(8),  
  [transport] varchar(8),  
  [operation] varchar(8),  
  [uri] varchar(255),  
  [mimetype] varchar(32),  
  [objectsource] varchar(12),  
  [resultcode] int,  
  [CacheInfo] int,  
  [rule#1] nvarchar(128),  
  [rule#2] nvarchar(128),  
  [sessionid] int,  
  [connectionid] int  
  )  
   
  CREATE     INDEX   [IX_FirewallLog_Date]   ON   [FirewallLog]([logDate])   ON   [PRIMARY]  
  GO  
   
    CREATE     INDEX   [IX_FirewallLog_DateTime]   ON   [FirewallLog]([logDate],   [logTime])   ON   [PRIMARY]  
  GO

转载于:https://www.cnblogs.com/fengzhifengyi/archive/2008/08/07/1262740.html