请教:碧血剑的<异构数据库之间完全可以用SQL语句导数据>。请高手帮忙.(50分)

W

walimg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-26

• #1

http://www.delphibbs.com/delphibbs/dispq.asp?lid=1691966<br>来自：碧血剑<br>测试时想用Access表 -&gt;Excel表.<br>求解ADOConnection1的配置????请高手指导一下.<br>ADOQuery1.sql= select * into aaa from mdb in 'E:/db2.mdb'<br>aaa 是Excel表新表,E:/db2.mdb这个文件是存在的,里有mdb表.

 

蓝

蓝叶菱

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-26

• #2

Excel联接ADO串<br>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/temp/a.xls;Extended <br>Properties=&quot;Excel 8.0;HDR=Yes;&quot;;Persist Security Info=False<br>Extended Properties参数属性这样写 Excel 5.0;HDR=YES;IMEX=1

 

W

walimg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-26

• #3

ADOConnection1可以连接,<br>但是还是不行,可能要改哪个属性的值.<br>下面这句是没有错的吧,为什么不能转到excel呢?<br>select * into aaa from mdb in 'E:/db2.mdb'<br>请高手指导,谢谢.

 

W

walimg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-27

• #4

测试时想用Access表 -&gt;Excel表.<br>谢谢高手帮忙解答

 

轻

轻舞肥羊

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-27

• #5

连接字符串<br>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:/book1.xls;Extended Properties=Excel 8.0;Persist Security Info=False<br><br>// &nbsp; &nbsp;acm: TADOCommand;<br> &nbsp;acm.CommandText := 'select * into aaa from t2 in ''E:/db1.mdb''';<br> &nbsp;acm.Execute;<br>测试通过,如果你那不行,试试安装高版本的MDAC

 

W

walimg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-27

• #6

谢谢,可以了.

 

W

walimg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-27

• #7

多人接受答案了。