如何把EXCEL表直接导入SQL SERVER2000呀？

[flymanwlq]

谢谢亚

[txlicenhe]

1:DTS
2: BULK INSERT pubs..authors2 FROM 'c:\22.xls'
3: SELECT * into 表
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions

[hjb111]

1、使用导入导出！
2、使用DTS

[愉快的登山者]

EXEC master..xp_cmdshell 'bcp "dbname..tablename" in c:\DT.xls -c -Sservername -Usa -Ppassword'

[pengdali]

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions


EXEC sp_addlinkedserver 'ExcelSource',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'c:\Temp\Part.xls',
NULL,
'Excel 5.0'
GO

或：


EXEC sp_addlinkedsrvlogin 'excelsource', 'false', NULL, NULL, NULL

在excel中选定范围,选择菜单'插入'->'名称'->'定义'

示例

SELECT *
FROM EXCEL...SalesData (整页使用 Sheet1$)

如果碰到转换为NULL值请使用文本文件来做DTS转换

[hjb111]

bulk insert yourdatabase..yourtable from 'd:\...\yourexecl.xls'
select * into yourdatabase..yourtable from FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\..\yourexcel.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1

[CrazyFor]

DTS导入.

[52vc]

up