| 導購 | 订阅 | 在线投稿
分享
 
 
 

如何將excel的數據導入到數據窗口中

來源:互聯網  2008-10-25 09:18:20  評論

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

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
󰈣󰈤
王朝萬家燈火計劃
期待原創作者加盟
 
 
 
>>返回首頁<<
 
 
 
 
 熱帖排行
 
 
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有