MSFlexGrid1.FixedRows = 1
MSFlexGrid1.Rows = 5
MSFlexGrid1.FixedCols = 1
MSFlexGrid1.Cols = 5
For i = 1 To MSFlexGrid1.Rows - 1
MSFlexGrid1.TextMatrix(i, 0) = i
Next
strSql="SELECT IDENTITY(int, 1,1) AS 序号,YourTable.Field1 AS 中文名称1,... INTO newTempTable FROM YourTable"
...
set MSHFlexGrid1.DataSource=rs
...
strSql="DROP TABLE newTempTable "
cn.Execute strSql