数据导入问题 ( 积分: 50 )

W

wood993903

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-27

• #1

如何将excel用sql语句导入sql server数据库

 

C

ChrisMao

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-27

• #2

SELECT * FROM OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,
’Data Source="c:/test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0’)...[Sheet1$]

 

无

无柄叶

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-27

• #3

楼上正解。。。

 

W

wood993903

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-05

• #4

接受答案了.