Dim Builder As New ADOXBuilder("订单1") '要指定数据源名称 Dim tbl As ADOXTable Builder.Open() tbl = Builder.NewTable("订单情况") '创建表 For Each dc As DataCol In DataTables("订单情况").DataCols With tbl Select Case dc.DataType.Name Case "String" .AddColumn(dc.Name ,ADOXType.String,100) Case "DateTime" .AddColumn(dc.Name ,ADOXType.DateTime) Case "Boolean" .AddColumn(dc.Name ,ADOXType.Boolean) Case "Double" .AddColumn(dc.Name ,ADOXType.Double) Case "Text" .AddColumn(dc.Name ,ADOXType.Text) End Select End With Next Builder.AddTable(tbl, True, True) '增加表 Builder.Close()
|