摘要： 讨论了ORACLE BLOB存储的有关特点,并利用VB和ADO技术,提出了一种用AppendChunk方法将Excel文件直接保存到Oracle的 BLOB字段中。以及用GetChunk方法将Oracle的BLOB字段中内容读到Excel文件中去的设计方法和实现实例,实现了单Excel文件管理的数据 库化。
关键词:
Excel,
ADO,
存取,
Oracle
Abstract: In order to store Excel document, Oracle database provides a date type--BLOB.This paper introduces a new method of operating BLOB field type in which Excel document can be put into BLOB by using an ADO function named AppendChunk and Excel document can be got from BLOB by using an ADO function named GetChunk.
中图分类号:
赵鲁东. Excel文件在Oracle上的存取技术[J]. , 2004, 30(S1): 598-599.
ZHAO Ludong. The Technology of Storaging Excel Document to Oracle Database[J]. , 2004, 30(S1): 598-599.