Excel 数据导入问题!请大家帮忙!(30分)

W

woaiwojia307

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-05-10

• #1

ADOConnection1.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' +
Excelpath +';Extended Properties=Excel 8.0;Persist Security Info=False';
ADOConnection1.Connected := true;
ADOConnection1.GetTableNames(ComboBox1.Items);
代码导入 Excel 中数据,可怎么给 Excelpath 赋值找出路径呀?

 

V

vvyang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-05-10

• #2

弹出“打开”对话框，用 OpenDialog.FileName 给Excelpath赋值

 

W

woaiwojia307

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-05-10

• #3

我是新手!能写得清楚一点嘛?谢谢!

 

W

woaiwojia307

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-05-10

• #4

有没有朋友指点指点!在线等!谢谢!

 

B

blyb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-05-10

• #5

http://www.delphibbs.com/delphibbs/dispq.asp?lid=1691966

 

W

woaiwojia307

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-05-10

• #6

谢谢大家!