This a p熟悉SQL SERVER 2000的数据库管理员都知道，其DTS可以进行数据的导入导出，其实，我们也可以使用Transact...

This a p熟悉SQL SERVER 2000的数据库管理员都知道，其DTS可以进行数据的导入导出，其实，我们也可以使用Transact-SQL语句进行导入导出操作。在 Transact-SQL语句中，我们主要使用OpenDataSource函数、OPENROWSET 函数，关于函数的详细说明，请参考SQL联机帮助。利用下述方法，可以十分容易地实现SQL SERVER、ACCESS、EXCEL数据转换，hoto of a general purpose timer/counter card you can wirewrap in a weekend. It plugs into your PC s ISA bus just like a sound or modem card. It gives high-resolution timing (microseconds). Because of its programmablity, it is very powerful and flexible. You can even control DC or servo motors using pulse-width modulated (PWM), or stepper motors using its square wave capabilities. The figure below is the actual output (square wave) from the 8254 card captured by an oscilloscope: -This a p familiar with the SQL Server 2000 database administrators know, the DTS can import data is derived, in fact, we can also use Transact-SQL for importing and exporting operation. The Transact-SQL statements, we mainly use OpenDataSource function, OPENROWSET function, the function of the details, please

SQL SERVER与ACCESS、EXCEL数据转换.doc