怎样连接、查询EXCEL表 ( 积分: 30 )

W

wglifs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #1

能用ADO里的组件连接EXCEL文件，如能连接，怎么连？连接后怎样进行查询？
不能用ADO的话，还有一些什么方法？

 

7

76004095

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #2

kk

 

X

xuege007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #3

能用的呀

 

C

cdj000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #4

找一下以前的富翁资料 有不少介绍

 

G

greenwon

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #5

可以用ADO连接啊。
adoconnection1.ConnectionString:=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=工资表.xls;Mode=Read;Extended Properties=Excel 8.0;Persist Security Info=False';
adoconnection1.open;
这样就连接到了"工资表.xls"

 

S

songrun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #6

同意樓上，或者用sql server的鏈接服務器

 

K

kaida

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #7

ADOConnection1.Connected:=False;
ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/TTT.xls;Extended Properties=Excel 8.0;Persist Security Info=False';
ADOConnection1.Connected:=True;
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('SELECT date,name,types FROM [excel 8.0;database=C:/TTT.xls].[Sheet1$] WHERE types LIKE "%'+Edit1.Text+'%"');
ADOQuery1.Open;
end;

 

W

wglifs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-11

• #8

好了，kaida接受积分。谢谢各位的帮助。