各位专家,大虾:
请帮助解决这个问题。我现在开发一个网站,其中涉及到这样一项功能:将本地的ACCESS数据库里的数据按条件导入到网站服务器的SQL里?有没有什么好的方法,或者有没有这样的源代码。本人将非常感激,我已经在网上找了很多资料,但都没什么效果,很急啊。如能提供代码,我愿意以现金的方式直接支付给您,谢谢!
请帮助解决这个问题。我现在开发一个网站,其中涉及到这样一项功能:将本地的ACCESS数据库里的数据按条件导入到网站服务器的SQL里?有没有什么好的方法,或者有没有这样的源代码。本人将非常感激,我已经在网上找了很多资料,但都没什么效果,很急啊。如能提供代码,我愿意以现金的方式直接支付给您,谢谢!
解决方案 »
- Vs2003做的程序部署问题
- C# UserControl
- ascx图片问题
- 命名空间同时存在于两个文件中造成的编译不通过
- 搞不懂的一个小问题?c#2005..................................
- 科大讯飞4.0 SDK C#的开发
- 关于文件存储的 问题
- 关于XML中的时间转换的方法!
- DCOM和COM+谁先出来,什么关系?有文章: 把你的组件放到COM+中,或者放到MTS中 , 可以单独放 ?只COM+,无MTS时,还支持分布式事务?不会VB等,
- 有没有这样的用法?int nIndex = new int ();
- 超时时间已到,在操作完成之前超时时间已过或服务器未响应
- C#连接Oracle数据库的完整代码(高分跪求)
其中有column1,column2,clumn3三列。
你想把column3条件为column3 = 'Y'的数据插入到sqlsever中去
sqlsever表table2,列名为col1,col2,col3
在access表中查询:
select 'insert into table2(col1,col2,col3) values('''|| column1 ||''','''|| column2 ||''',''Y'');'
from table1 where column3 = 'Y';将查询中得数据粘贴出来,在sqlSever中执行即可。
Imports System.Data.OracleClient
Public Class excel_orcal
Inherits System.Windows.Forms.Form
Dim app As Excel.Application
Dim ws As Excel.Worksheet
Dim wb As Excel.Workbook
Dim j As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.OpenFileDialog1.ShowDialog()
Me.TextBox1.Text = Me.OpenFileDialog1.FileName
app = CreateObject("Excel.Application")
app.Visible = True
wb = app.Workbooks.Open(TextBox1.Text)
ws = app.Worksheets(1)
ws.Activate()
System.Runtime.InteropServices.Marshal.ReleaseComObject(app)
app = Nothing
GC.Collect()
'sqlstr = ws.Cells(1, 2).value
'sqlstr = app.WorksheetFunction.Max(ws.Range("B2:F10"))
' Me.Label1.Text = sqlstr
End Sub
Private Sub create_table()
For j = 1 To 100
sqlstr = sqlstr + ws.Cells(1, j).value & " " & "VARCHAR2(1000),"
If ws.Cells(1, j).value = "" Then
Exit For
End If
Next
Dim a As String
Dim b As Integer
input = InputBox("请输入需要键的表名", , ws.Name)
b = sqlstr.Length - 17
a = sqlstr.Substring(0, b)
sqlstr = "select * from user_all_tables where table_name='" & input & "'"
If Get_ds(sqlstr).Tables(0).Rows.Count = 0 Then
MsgBox("该表存在,不需要创建?", MsgBoxStyle.YesNo, "提示")
sqlstr = "create table" + " " & input & "(" & a & " )"
MsgBox("生成其他的表")
edit_data(sqlstr)
End If
Me.RichTextBox1.Text = sqlstr
End Sub
Private Function ms(ByVal i As Integer) As String
For x = 1 To j - 1
c = c + "'" + CStr(ws.Cells(i, x).value) + "',"
Next
b = c.Length - 1
a = c.Substring(0, b)
Return a
End Function
Private Function y() As Integer
For d = 1 To 1000
If ws.Cells(d, 1).value = "" And ws.Cells(d + 10, 1).value = "" Then
Return d
Exit For
End If
Next
End Function
Dim input As String
Dim i As Integer
Dim x As Integer
Dim c As String
Dim a As String
Dim d As Integer
Dim b As Integer
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
sqlstr = ""
create_table()
Try
Me.TextBox2.Text = y() - 1
Me.RichTextBox1.Text = ""
For i = 2 To y() - 1
c = ""
sqlstr = "insert into" & " " & input & " values( " + ms(i) + ")"
edit_data(sqlstr)
Me.RichTextBox1.Text = Me.RichTextBox1.Text + sqlstr + ";------插入成功" + vbCrLf
Next
Catch ex As Exception
End Try
End Sub
End Class
Public Function edit_data(ByVal sqlstr As String) As Boolean
Dim cmd As OracleCommand = New OracleCommand
Try
conn.Open()
cmd.Connection = conn
cmd.CommandText = sqlstr
cmd.CommandType = CommandType.Text
cmd.ExecuteNonQuery()
conn.Close()
Return True
Catch ex As Exception
MsgBox("操作失败,连接数据库失败或无相关数据!")
Return False
End Try
End Function