请问一个关于文本文件导入数据库的问题,简单,高手赐教! 想用vb操作文本文件导入数据表,并且是在原有的记录上追加,当碰到主键相同的情况下提示用户是否覆盖,请问如何实现? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你参考一下下面的代码吧InputFileName = g_AppPath & "\" & InputFileName fileNumber = FreeFile Open InputFileName For Binary Access Read As fileNumber DataLen = LOF(fileNumber) ReDim varData(DataLen - 1) As Byte Get fileNumber, , varData() Set cnn = New ADODB.Connection strCnn = "Provider=SQLOLEDB;" & "Data Source=" & g_strServerName & ";" _ & "Initial Catalog=" & DBName & ";User ID=" & g_strUserID & ";" _ & "Password=" & g_strUserPwd & ";" cnn.Open strCnn Set rs = New ADODB.Recordset rs.Open TableName, cnn, adOpenKeyset, adLockOptimistic, adCmdTable rs.AddNew rs.Fields(FileFieldName).Value = FileName rs.Fields(FileData).Value = varData rs.Update Close fileNumber rs.Close 求更改com口号API 挥泪告别CSDN两个月,散尽家财:( mdsn有什么用! 救命啊!一个汉字怎么会有两个asc值??? 我在VB程序中该怎么样调出扫描仪的扫描界面? 郁悶中........用DATAGRID的疑問 什么是DLL,API,COM,解释清楚的给高分!! Form中用picture做背景,800*600的图片,改换显示器分辨率后存在问题。急!!! 无效使用null的问题 ********vb6做的程序能怎么伪装成是vb.net做的吗?有用.谢谢! AGENT这样用错误在哪里? 怎样使vsflexgrid控件中单元格中的内容多行显示
InputFileName = g_AppPath & "\" & InputFileName
fileNumber = FreeFile
Open InputFileName For Binary Access Read As fileNumber
DataLen = LOF(fileNumber) ReDim varData(DataLen - 1) As Byte
Get fileNumber, , varData()
Set cnn = New ADODB.Connection
strCnn = "Provider=SQLOLEDB;" & "Data Source=" & g_strServerName & ";" _
& "Initial Catalog=" & DBName & ";User ID=" & g_strUserID & ";" _
& "Password=" & g_strUserPwd & ";" cnn.Open strCnn
Set rs = New ADODB.Recordset rs.Open TableName, cnn, adOpenKeyset, adLockOptimistic, adCmdTable
rs.AddNew
rs.Fields(FileFieldName).Value = FileName
rs.Fields(FileData).Value = varData
rs.Update
Close fileNumber
rs.Close