 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
异构数据库之间的导入导出 //MSSQL2EXCEL ADOConnection1.ConnectionString:= \\\'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:mysmallexeexcel2sqlyp.xls;\\\' +\\\'Extended Properties=excel 8.0\\\'; ADOConnection1.Execute(\\\'select * into [Abc] from drug_yk IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=kcsoft58;Server=127.0.0.1;DataBase=kcsoft_his]\\\'); //把一个MSSQL的数据库表及数据导出到excel中,abc为excel中不存在的表名，drug_yk为MSSQL里的表, sa为 用户, kcsoft58为密码 , 127.0.0.1为服务大地址 ，kcsoft_his是数据库名称 ADOConnection1.Execute(\\\'insert into [abc] select * from drug_yk in [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=kcsoft58;Server=127.0.0.1;DataBase=kcsoft_his]\\\'); //把一个MSSQL的数据库表的记录增加到到excel中，执行以后相称于两倍量的数据，一次是导入，一次是 insert //EXCEL2MSSQL ADOConnection1.ConnectionString:=\\\'Provider=SQLOLEDB.1;Password=KCSOFT58;Persist Security Info=True;User ID=SA;Initial Catalog=KCSOFT_HIS;Data Source=CHEN\\\'; ADOConnection1.Execute(\\\'SELECT * into [abc] FROM OpenDataSource( \\\' +QuotedStr(\\\'Microsoft.Jet.OLEDB.4.0\\\')+\\\',\\\' +QuotedStr(\\\'Data Source="G:mysmallexeexcel2sqlyp.xls";Extended Properties=excel 8.0\\\') +\\\')...[Abc]\\\'); //MSSQL2VFP ADOConnection2.ConnectionString:= \\\'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:mysmallexeexcel2sql;\\\' +\\\'Extended Properties=dBase 5.0\\\'; ADOConnection2.Execute(\\\'select * into Abc.dbf from drug_yk IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=kcsoft58;Server=127.0.0.1;DataBase=kcsoft_his]\\\'); //把一个MSSQL的数据库表及数据导出到VFP中,Abc.dbf 为VFP中不存在的表名，drug_yk为MSSQL里的表, sa为 用户, kcsoft58为密码 , 127.0.0.1为服务大地址 ，kcsoft_his是数据库名称 //VFP2MSSQL ADOConnection2.ConnectionString:=\\\'Provider=SQLOLEDB.1;Password=KCSOFT58;Persist Security Info=True;User ID=SA;Initial Catalog=KCSOFT_HIS;Data Source=CHEN\\\'; ADOConnection2.Execute(\\\'SELECT * into [abc] FROM OpenDataSource( \\\' +QuotedStr(\\\'Microsoft.Jet.OLEDB.4.0\\\')+\\\',\\\' +QuotedStr(\\\'Data Source="G:mysmallexeexcel2sql";Extended Properties=dBase 5.0\\\')+\\\')... [Abc]\\\'); //MSSQL2access ADOConnection2.ConnectionString:= \\\'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:mysmallexeexcel2sqlServer.MDB;\\\' +\\\'Persist Security Info=False;Jet OLEDB:Database Password=happynewyear\\\'; ADOConnection2.Execute(\\\'select * into Abc from drug_yk IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=kcsoft58;Server=127.0.0.1;DataBase=kcsoft_his]\\\'); //access2MSSQL ADOConnection2.ConnectionString:=\\\'Provider=SQLOLEDB.1;Password=KCSOFT58;Persist Security Info=True;User ID=SA;Initial Catalog=KCSOFT_HIS;Data Source=CHEN\\\'; ADOConnection2.Execute(\\\'SELECT * into [abc] FROM OpenDataSource( \\\' +QuotedStr(\\\'Microsoft.Jet.OLEDB.4.0\\\')+\\\',\\\' +QuotedStr(\\\'Data Source="G:mysmallexeexcel2sqlServer.MDB";Jet OLEDB:Database Password=happynewyear\\\')+\\\')...[Abc]\\\'); //excel2access ADOConnection2.ConnectionString:= \\\'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:mysmallexeexcel2sqlServer.MDB;\\\' +\\\'Persist Security Info=False;Jet OLEDB:Database Password=happynewyear\\\'; ADOConnection2.Execute(\\\'SELECT * into [abc] FROM [excel 8.0;database=G:mysmallexeexcel2sqlyp.xls].[abc$]\\\'); //access2excel ADOConnection2.ConnectionString:= \\\'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:mysmallexeexcel2sqlyp.xls;\\\' +\\\'Extended Properties=excel 8.0\\\'; ADOConnection2.Execute(\\\'SELECT * into abc from [G:mysmallexeexcel2sqlServer.MDB;pwd=happynewyear].abc\\\'); //MSSQL2txt ADOConnection2.ConnectionString:= \\\'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:mysmallexeexcel2sql;\\\' +\\\'Extended Properties=text\\\'; ADOConnection2.Execute(\\\'select * into Abc#txt from drug_yk IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=kcsoft58;Server=127.0.0.1;DataBase=kcsoft_his]\\\'); //txt2MSSQL ADOConnection2.ConnectionString:=\\\'Provider=SQLOLEDB.1;Password=KCSOFT58;Persist Security Info=True;User ID=SA;Initial Catalog=KCSOFT_HIS;Data Source=CHEN\\\'; ADOConnection2.Execute(\\\'SELECT * into [abc] FROM OpenDataSource( \\\' +QuotedStr(\\\'Microsoft.Jet.OLEDB.4.0\\\')+\\\',\\\' +QuotedStr(\\\'Data Source="G:mysmallexeexcel2sql";Extended Properties=text\\\')+\\\')... [Abc#txt]\\\'); 返回类别: 教程 上一教程: SQL SERVER数据对象结构的动态建立与访问 下一教程: 确保所有的非空(NON-NULL)值都是唯一的 您可以阅读与"异构数据库之间的导入导出"相关的教程: · MYSQL数据库结构和数据的导出和导入 · 从MYSQL导入导出大量数据的程序实现方式 · 怎样将MYSQL数据库结构和数据导出或导入 · 三大数据库之间对比 · 从 MYSQL 导入导出大量数据的程序实现方式 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
