利用ADO实现数据导入导出的关键技术

The Key Technologies of Realizing Data's Input and Output by ADO

给出了VC++利用ADO实现与Excel,Access,VisualFoxpro,SQLServer数据库之间的数据导入导出的关键技术:连接到不同的数据源的方法;针对不同数据库类型给出创建数据表的SQL语句;将数据写入不同数据库类型的数据表;针对不同数据库类型的给出查询语句等。

This paper introduces the key technologies of VC ＋＋ realizing dam＇s input and output with Excel, Access, Visual Foxpro and SQL Server by ADO. The technologies include how to link to various data sources; how to give the correct SQL sentence for creating data table to various database, how to input data into table to various database and how to give the correct searching sentence to various database, etc.