34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT
*
into ss
FROM OpenDataSource
('Microsoft.Jet.OLEDB.4.0',
'Data Source="G:\SQL\aa.xls";User ID=Admin;Password=;Extended properties=''Excel 5.0;HDR=yes;IMEX=1''')...sheet1$
select * from ss
aaa
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
123456789
asfasdfas
n/a
...
4240
4520
4200
1500
NULL
(9 行受影响)
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U'))
DROP TABLE [TB]
GO
---->建表
create table [TB]([ID] varchar(90))
insert [TB]
select '123456789' union all
select 'asfasdfas' union all
select 'n/a'
GO
--> 查询结果
SELECT * FROM [TB]
--> 删除表格
--DROP TABLE [TB]