用SQL Server自带的实用程序bcp可以把表倒成txt文件,也可以把这个文件倒入表!
bcp tablename out c:\windows\desktop\docu_dict.txt -T -S server
bcp dbname..tablename in c:\windows\desktop\User.txt -S
具体参数你自己要研究一下了!
bcp tablename out c:\windows\desktop\docu_dict.txt -T -S server
bcp dbname..tablename in c:\windows\desktop\User.txt -S
具体参数你自己要研究一下了!
Set datt = Workspaces(0).OpenDatabase("sbc", dbDriverNoPrompt, False, "DSN=sbc;UID=sa;PWD=;DATABASE=" & Combo1 & ";") SQL = "select * into [;database=" + App.Path + "\temp.mdb ].codesize from codesize where 1=1" datl.Execute "drop table codesize "
datt.Execute SQL