如何将excel的数据导入到数据窗口中

来源:岁月联盟 编辑:zhu 时间:2008-10-25
如何将excel的数据导入到数据窗口中内容简介:transaction access access = CREATE transaction access.DBMS = transaction access
access = CREATE transaction
access.DBMS = 'ODB'
access.DBParm = "ConnectString='Driver={Microsoft Excel Driver (*.xls)};Dbq=" +文件名+ ";Uid=;Pwd='"
CONNECT USING access ;
IF access.SQLCode <> 0 THEN
m_errmsg=access.SQLErrText
Return -1
END IF
atr_cnn=access

图片内容