Archive for 4月 3rd, 2006

从Excel导数据到sql server出现NULL的问题

Bright Posted on 2006-4-3 17:00 | Views(1,199) | Comments (1) | Category: MS SQL | Tags:

今天一同事在用SQL Server的OPENROWSET函数从Excel中导数据到SQL Server时出现中文数据变成NULL，其语句是这样的：
select a.* from OPENROWSET(’Microsoft.JET.OLEDB.4.0′,
‘Excel 8.0;Database=c:\students.xls;’,
‘SELECT * FROM [sheet1$]‘) as a
执行结果如下：
学籍管理 F2 [...]

Page 1 of 11

搜索本站

站点日历

订阅本站

订阅到Google Reader

订阅到鲜果

订阅到抓虾

订阅到有道

文章分类

English (4)
商务智能 (7)
存储 (1)
小米 (19)
操作系统 (15)
- Unix|Linux (12)
- Windows (3)
数据库 (96)
- MS SQL (21)
- Mysql (2)
- Oracle (73)
网络 (5)
随笔 (63)

最新日志

热点文章

ORA-02019: connection description for remote database not found (11,328)
expdp常见用法 (10,886)
ORA-01102: cannot mount database in EXCLUSIVE mode (10,373)
IMP-00010: 不是有效的导出文件，标题验证失败 (8,970)
一则ora-03113错误的解决 (8,113)
CRS无法启动的解决过程 (7,553)
ORA-12500: TNS: 监听程序无法启动专用服务器进程 (6,668)
ORA-12545:Connect failed because target host or object does not exist (6,661)
Checking monitor:must be configured to display at least 256 colors (6,432)
ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (4,442)
ORA-12535: TNS: 操作超时 (4,417)
ORA-12528: TNS:listener: all appropriate instances are blocking new connections (4,382)
【ZT】Oracle分布式事务故障处理 (4,346)
Oracle CRS log (4,312)
ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (4,308)
苏州圆融时代广场 (3,867)
Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (3,692)
WARNING: inbound connection timed out (ORA-3136) (3,639)
2010第一贴 (3,295)
ANS1312E (RC12) Server media mount not possible (3,265)

日志存档

常用标签