Jover(Java):谢谢老兄!!我又可以up了
解决方案 »
- vb高手来帮忙(VB换肤)
- wscript.sleep 最长睡眠多少?
- 用VB自带的data report访问SQL SERVER中的数据,在我的机器上调试没有问题,报表能够显示出来,打包后安装在别的机器上,出现“无效数据源”的错误
- 请问如何获取软件的路径?
- msflexgrid显示大容量数据的问题
- 请问winsock同时处理多个连接进行传输的情况下效率如何?
- 复制表结构的sql怎么写??????在线等待
- 如何连接网络注册表?
- vb中如何连接sql analysis service?
- 如何在IMG上画图?
- 有没有人作过触摸屏的查询系统?能不能介绍一下,接口?能用vb编程吗?有没有vb接口?
- 急急..我正在使用的win98,装上winme,还用装显卡的驱动程序吗.
Q_StrCnn = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" + CurDir() + "\*.mdb"
Q_Cnn.Open Q_StrCnn
Set J_Comman = New ADODB.Command
J_Comman.ActiveConnection = Q_Cnn
J_Comman.CommandTimeout = 300
J_Comman.commandtext="delete [1].* from [2] where [1].[1]=[2].[2]"
J_Comman.Execute
x.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\XXX.mdb;Persist Security Info=False"
'x.Execute "SELECT * INTO [D:\Target.mdb].[CopyOfTable1] FROM [D:\Source.mdb].[Table1]"
x.Execute "INSERT INTO [D:\Target.mdb].[CopyOfTable1] SELECT * FROM [D:\Source.mdb].[Table1]"
tianao0001(莱因哈特):谢谢了!兄弟!!!!!
紧急!!!一定给分!!
还有那位大虾看到了!!帮帮忙!!!!
Dim adoConnectionX As New ADODB.Connection
adoConnectionX.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Data Source=YourServerName;DataBase=YourDatabaseName"
adoConnectionX.Execute "SELECT * INTO [TableOfSQL] FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=..\..\XXX.mdb')...[TableOfAccess]"
adoConnectionX.Execute "INSERT INTO [TableOfSQL] SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=..\..\northwind.mdb')...[TableOfAccess]"
我的表在那里!!1
我的表在那里!!1
参阅:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_2be1.asp 关于SQL和ACCESS的导入导出问题
http://www.csdn.net/expert/topic/298/298892.shtm
Dim rsDeclCode As New ADODB.Recordset
Dim StrSql As String
Dim path As String path = App.path If Right(path, 1) <> "\" Then path = path & "\"
If rsDeclCode.State = adStateOpen Then rsDeclCode.Close
StrSql = "select decl_no from t_goods_decl where decl_date>=#" & Date - 30 & "# and decl_date <= # " & Date & " # and decl_no like '210%'"
Do While Not rsDeclCode.EOFconOraDestination.Execute "SELECT * into [t_fee_list] FROM opendatasource('microsoft.jet.oledb.4.0','data source=f:\temp.mdb').[t_fee_list]"conOraDestination.Execute "INSERT [t_fee_list] SELECT * FROM opendatasource('microsoft.jet.oledb.4.0','data source=f:\temp.mdb').[t_fee_list]" & _
"where decl_no='" & rsDeclCode!decl_no & "'" rsDeclCode.MoveNextLoopend sub系统提示:错误的表名 t_fee_list
这是怎么回事???
应该是 "..." 3 个"黑点"儿
cmm.commandtype=Proc.... (具体的我记不清了。你自己查一下吧,VB有提示的)
cmm.execute
报错!ad hoc access to oledb provider 'microsoft.jet.oledb.4.0' has been denied.you must access this provider through a linked server.
这是个什么错误???
[OLE/DB provider returned message: 'f:\temp.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.]
这就是测试结果!我找了!在f:\有temp.mdb数据库!这又是怎么会事情呢?
playyuer(女㊣爱):能不能再帮帮忙!
我用"Provider=Microsoft.Jet.OLEDB.3.51;Data Source=数据库名(*.mdb)"
当我打包安装时出错:“未找到提供者,可能为未被正确安装”
我的VB是正版的,打包应该没有问题啊!
能帮帮我吗?
或者去打个补丁!vb6.0的补丁!
我查找了,可是不知道是什么错误!!帮帮忙!!!
系统提示:privider returned message unspecified error
就是在执行完:adoConnectionX.Execute "INSERT INTO [TableOfSQL] SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=..\..\northwind.mdb')...[TableOfAccess]" 以后!!!!该怎么办?????
你用"Provider=Microsoft.Jet.OLEDB.3.51;Data Source=数据库名(*.mdb)"
是怎么打包安装到目标机的!!!