Table_name=request.QueryString("Table_name")
Set rs= Server.CreateObject("ADODB.Recordset")
Const adSchemaTables = 20
adSchemaColumns = 4
strConn="DBQ="+server.mappath("db.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.open strConn
Set rstSchema = oConn.OpenSchema(adSchemaColumns)
Set rsttable = oConn.OpenSchema(adSchemaTables)
i=0
1<?xml version="1.0" encoding="gb2312"?>
2>
>
> ```
=Table_name
```
>
> ```
> //生成XML文件头
> Do Until rstSchema.EOF
> if rstSchema("Table_name") = Table_name then
> if rstschema("column_Name")<>"ORowInfo" or rstschema("column_Name")<>"osysMachineID" then
>
1> <fieldname>```
2=rstschema("column_Name")
3```</fieldname> <colname>```
4=rstschema("column_Name")
5```</colname>
6> ```
7select case rstschema("data_type")
8&gt; case "130"
9&gt; if rstschema("CHARACTER_MAXIMUM_LENGTH") = 1073741823 then
10``` <datatype>12</datatype>
11> <celltype>0</celltype>
12> ```
13else
14``` <datatype>10</datatype>
15> <celltype>0</celltype>
16> ```
17end if
18&gt; case 135
19``` <datatype>23</datatype>
20> <celltype>3</celltype>
21> ```
22case 3
23``` <datatype>7</datatype>
24> <celltype>0</celltype>
25> ```
26case 11
27``` <datatype>3</datatype>
28> <celltype>2</celltype>
29> ```
30case 131
31``` <datatype>10</datatype>
32> <celltype>0</celltype>
33> ```
34case 5
35``` <datatype>7</datatype>
36> <celltype>0</celltype>
37> ```
38case else
39``` <datatype>10</datatype>
40> <celltype>0</celltype>
41> ```
42end select
43``` </fieldinfo>
44> ```
45end if
46&gt; end if
47&gt; rstSchema.MoveNextLoop
48&gt;
49``` </fieldinfoarray>
50> </tableinfo>
51> <rows>
52> //生成XML文件体
53> ```
5455&gt; sql="select * from "&amp;Table_name
56&gt; rs.open sql,strConn,1,1
57&gt; Do while Not rs.eof
58&gt;
59``` <row>
60> ```
6162&gt; for k=0 to rs.fields.count-1
63&gt; if rs(k).name&lt;&gt;"ORowInfo" or rs(k).name&lt;&gt;"osysMachineID" then
64&gt;
65``` <```
66=rs(k).name
67```>```
68=rs(k)
69```<!--```
70=rs(k).name
71```-->
72> ```
7374&gt; end if
75&gt; next
76&gt;
77``` </row>
78> ```
7980&gt; rs.movenext
81&gt; loop
82&gt; rs.close
83&gt;
84``` </rows>
85> </table>