请各路高手提供类似这样的信息：
SQL SERVER ：
连接串："Provider=sqloledb;Data Source=" & ServerName & ";Initial Catalog=" & DatabasName & ";User Id=" & UserName & ";password=" & PassWord & "; "
插入语句："insert into " & TableName & "(" & FieldNameChar & "," & FieldNameNum & "," & FieldNameDate & ") values ('Yang_',100,'2002-5-9')"
查询语句："select " & FieldNameChar & "," & FieldNameNum & "," & FieldNameDate & " from " & TableName & " where " & FieldNameChar & "='Yang_' and " & FieldNameBum & "=100 and " & FieldNameDate & " butween '2002-5-9' and '2002-5-20'"
Access ：
连接串："Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=DBQ=" & ServerName & DataBaseName & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=" & UserName & ";UserCommitSync=Yes; PWD=" & PassWord & ";"
插入语句："insert into " & TableName & "(" & FieldNameChar & "," & FieldNameNum & "," & FieldNameDate & ") values ('Yang_',100,#2002-5-9#)"
查询语句："select " & FieldNameChar & "," & FieldNameNum & "," & FieldNameDate & " from " & TableName & " where " & FieldNameChar & "='Yang_' and " & FieldNameBum & "=100 and " & FieldNameDate & " butween #2002-5-9# and #2002-5-20#"
我现在才搞定SQL SERVER 和ACCESS，其他的请大家帮忙，重点是ORACLE、SYBASE、MYSQL、INTERBASE、DB2、Paradox、文本文件、EXCEL、DBF等，可能还有其他许多我没有听说过的数据库，也多谢提供。
如果嫌麻烦，写成其他格式也可以，只要估计我能看懂，看不懂时我再问。
谢谢！
