SELECT CAST(所属知识点 AS VARCHAR(8000)) AS 所属知识点,
CAST(试题题面 AS VARCHAR(8000)) AS 试题题面,
CAST(试题类型 AS VARCHAR(8000)) AS 试题类型,
CAST(备选答案1 AS VARCHAR(8000)) AS 备选答案1,
CAST(备选答案2 AS VARCHAR(8000)) AS 备选答案2,
CAST(备选答案3 AS VARCHAR(8000)) AS 备选答案3,
CAST(备选答案4 AS VARCHAR(8000)) AS 备选答案4,
CAST(备选答案5 AS VARCHAR(8000)) AS 备选答案5,
CAST(正解答案 AS VARCHAR(8000)) AS 正解答案,
CAST(人员类型 AS VARCHAR(8000)) AS 人员类型,
CAST(工种 AS VARCHAR(8000)) AS 工种,
CAST(培训类型 AS VARCHAR(8000)) AS 培训类型 into test
FROM openrowset( 'Microsoft.Jet.OLEDB.4.0',
'EXCEL 8.0;HDR=YES;IMEX=1; DATABASE=D:\考题.xls',ExamLib$)