如何将excel的数据导入到数据窗口中
2008-10-24 14:27:36 来源:WEB开发网核心提示:transaction accessaccess = CREATE transaction access.DBMS = 'ODB' access.DBParm = "ConnectString='Driver={Microsoft Excel Driver (*.xls)};Dbq=&
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
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
赞助商链接