【摘要】 SQL Server与文本应用程序之间的数据导入导出的实现主要有两种方法,一种是SQL Server本身提供的方法,另一种是通过编写客户端程序来实现数据的导入与导出功能;其中通过客户端程序来实现数据导入时采用的是ASP.net中提供的OLE DB Provider for Jet 4.0链接到Excel,将Excel数据读取到数据集对象中,数据导出是采用的是ASP.net中提供的StreamWriter类来实现的。更多还原

【Abstract】 There are two methods of data importing and exporting between SQL Server and text application program.The one method is provided by SQL Server,the other is to write client programs.The OLE DB Provider for Jet 4.0 of ASP.net can implement data importing by writing client program.It can connect to Excel,and read the excel data to dataset object.The StreamWriter class of ASP.net can implement data exporting by writing client program.更多还原