小弟初学VB~请教各位达淫~该怎么搞呢?
俺像下面这么写,失败了~救命!
cn.ConnectionTimeout = 100
cn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBC;" & _
"SourceDB=" & txt_foxfile.Text & _
";Exclusive=No;" cn.Execute "insert into [;DATABASE=" & Gs_App_Path & _
"\server.mdb;Pwd=null].Population_Info(Personal_ID,name,gender,folk,birthday,office,health,education" & _
",occupation,residence,register,marriage_record,marriage_status,consort,monther_son,firstmarriage_time" & _
",remarriage_time) values select 编号,姓名,性别,民族,出生日期" & _
",工作单位,健康状况,文化程度,职业状况,人户状况,户口性质,婚姻未报,婚姻状况" & _
",夫妻关系,母子关系,初婚时间,再婚时间 from 户内人口"
俺像下面这么写,失败了~救命!
cn.ConnectionTimeout = 100
cn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBC;" & _
"SourceDB=" & txt_foxfile.Text & _
";Exclusive=No;" cn.Execute "insert into [;DATABASE=" & Gs_App_Path & _
"\server.mdb;Pwd=null].Population_Info(Personal_ID,name,gender,folk,birthday,office,health,education" & _
",occupation,residence,register,marriage_record,marriage_status,consort,monther_son,firstmarriage_time" & _
",remarriage_time) values select 编号,姓名,性别,民族,出生日期" & _
",工作单位,健康状况,文化程度,职业状况,人户状况,户口性质,婚姻未报,婚姻状况" & _
",夫妻关系,母子关系,初婚时间,再婚时间 from 户内人口"
解决方案 »
- VB判断组件是否已经注册?
- 大侠 请赐教!!!急急
- 0x04;0x5F;0x00000000是什么格式来的,如要转成16进制的值是什么
- 导出Excel问题
- 急!请问我想做这个东西用什么控件好?
- 卸载问题!!!!!!!!!在线等候
- 如何在com中执行一个asp,将aps执行的结果html保存到磁盘上
- 500分求救!关于listview。在线等待
- 怎样在同一个Frame中得到几个不同群组的单选框?
- 请问怎样使用installshield6.1 professional在“开始”--“程序”菜单中创建程序组和快捷方式,请详细说明,谢谢!
- 如何通过代码修改ACCESS数据库中的数据类型?
- LGYAN(紫衣随想) 请进
"\server.mdb""" select 编号 as Personal_ID,姓名 as [name],性别 as gender,民族 as folk,出生日期 as birthday" & _
",工作单位 as office,健康状况 as health,文化程度 as education,职业状况 as occupation,人户状况 as residence,户口性质 as register,婚姻未报 as marriage_record,婚姻状况 as marriage_status" & _
",夫妻关系 as consort,母子关系 as monther_son,初婚时间 as firstmarriage_time,再婚时间 as remarriage_time from 户内人口"
"\server.mdb select 编号 as Personal_ID,姓名 as [name],性别 as gender,民族 as folk,出生日期 as birthday" & _
",工作单位 as office,健康状况 as health,文化程度 as education,职业状况 as occupation,人户状况 as residence,户口性质 as register,婚姻未报 as marriage_record,婚姻状况 as marriage_status" & _
",夫妻关系 as consort,母子关系 as monther_son,初婚时间 as firstmarriage_time,再婚时间 as remarriage_time from 户内人口"
cn.Execute "insert into OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source = " & Gs_App_Path & "\server.mdb" & ";User ID=Admin;Password=') select 编号,姓名,性别,民族,出生日期" & _
",工作单位,健康状况,文化程度,职业状况,人户状况,户口性质,婚姻未报,婚姻状况" & _
",夫妻关系,母子关系,初婚时间,再婚时间 from 户内人口"
是语法的问题还是连接的问题啊~哪里有语法帮助阿
Gs_App_Path & "\server.mdb';;'null','select Personal_ID,name,gender,folk" & _
",birthday,office,health,education,occupation,residence,register" & _
",marriage_record,marriage_status,consort,monther_son,firstmarriage_time" & _
" from Population_Info') " & _
" select 编号,姓名,性别,民族,出生日期" & _
",工作单位,健康状况,文化程度,职业状况,人户状况,户口性质,婚姻未报,婚姻状况" & _
",夫妻关系,母子关系,初婚时间,再婚时间 from 户内人口"