CREATE TABLE TEST(AA FLOAT)
--插入数据
INSERT INTO TEST
SELECT 8859.06 as AA
UNION ALL
SELECT 20442.29 as AA
UNION ALL
SELECT 61125.20 as AA
UNION ALL
SELECT 100001.41 as AA
UNION ALL
SELECT 1127331.86 as AA
--导出数据:
insert into OPENROWSET( 'Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:\TEST.XLSX;','select * from [test$]')
SELECT * FROM TEST
--导出TEST.XLSX结果:
AA
8859.06
20442.3
61125.2
100001
1.12733e+006
求解:小数位去哪呢,长了都变成了科学计算法?有什么方法或参数可以原样导出
...全文
3296打赏收藏
Microsoft.ACE.OLEDB.12.0导出数据问题
测试表: CREATE TABLE TEST(AA FLOAT) --插入数据 INSERT INTO TEST SELECT 8859.06 as AA UNION ALL SELECT 20442.29 as AA UNION ALL SELECT 61125.20 as AA UNION ALL SELECT 100001.41 as AA UNION ALL SELECT 1127331.86 as AA --导出数据: insert into OPENROWSET( 'Microsof