access互导.docVIP

access互导.txt如果我穷得还剩下一碗饭 我也会让你先吃饱全天下最好的东西都应该归我所有，包括你！！　　先说喜欢我能死啊?别闹，听话。　　有本事你就照顾好自己，不然就老老实实地让我来照顾你！　　整理一下： 解决了，我用的cb /* 功能 : Access To DBF ADOConnection2 = Access */ sql = SELECT * INTO jyjh in \c:\\temp\[dbase 5.0;] FROM jyjh; ADOConnection2-Execute(sql); c:\temp\aaa.dbf to Access, ADOConnection 指向Access 语句是 select * into bbb from aaa in c:\temp dbase 5.0; 在Form上放一个ADOConnection,连结指向目标Access库 比如txt文件在c:\temp\aaaa.txt 就执行 ADOConnection.Connected := True; ADOConnection.Execute(Select * Into abcd From [Text;Database=c:\temp].aaaa.txt); 将Oracle导入到文本文件 连接串 Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp;Extended Properties=text;HDR=YES;;Persist Security Info=False SQL语句 SELECT * into aaa.txt FROM Tab1 IN [ODBC] [ODBC;Driver={Microsoft ODBC for Oracle};UID=oracle;PWD=oracle;SERVER=yourdata;] 将Oracle导入到Access 连接串 Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\db1.mdb;Persist Security Info=False SQL语句 SELECT * into tablename FROM Tab1 IN [ODBC] [ODBC;Driver={Microsoft ODBC for Oracle};UID=oracle;PWD=oracle;SERVER=yourdata;] DBase 5.0 DBASE IV FoxPro 3.0 Paradox 7.X Excel 8.0 text;HDR=YES;FMT=Delimited SELECT * into aaa FROM OpenDataSource( Microsoft.Jet.OLEDB.4.0, Data Source=c:\temp\;User ID=Admin;Password=;Extended properties=Text)...[bb#txt] Excel联接ADO串 Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\a.xls;Extended Properties=Excel 8.0;HDR=Yes;;Persist Security Info=False Extended Properties参数属性这样写 Excel 5.0;HDR=YES;IMEX=1 IMEX=1就是指混合型转换为文本 SQLServer从Excel取数 SELECT * FROM OpenDataSource(Microsoft.Jet.OLEDB.4.0,Data Source=C:\temp\b.xls;Extended Properties=Excel 5.0;HDR=Yes;;Persist Security Info=False)...sheet1$ 将SQLServer导入到文本文件 连接串 Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp;Extended Properties=text;HDR=YES;;Persist Security Info=False SQL语句 SELECT * into aaa.txt FROM Tab1 IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=127.0.0.1;DataBase=Demo;] 要改变分隔符，可以修改 Schema.ini文件。该文件中指明分割符，如： [yourfile.txt] ... Format=Delimited(|)