Description: 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 refer to SQL online help. Use the following method, it is easy to SQL Server, Access, Excel data conversion, HOTO of a general purpose timer / counter card you can wirewrap in a weekend. It plugs into your PC ISA bus s just like a sound card or modem. It gives high-resolution timing (microseconds). Because of its programmablity, it is very powerful and flexible. You can even control or DC servo motors using pulse-width modulated (PWM), or Stepper motors using its square wave capabi Platform: |
Size: 5788 |
Author:海应 |
Hits:
Description: 一个把SQL Server中的表导为Excel中标的例子-On a table in SQL Server Introduction to the successful examples of Excel Platform: |
Size: 74752 |
Author:站长 |
Hits:
Description: 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 refer to SQL online help. Use the following method, it is easy to SQL Server, Access, Excel data conversion, HOTO of a general purpose timer/counter card you can wirewrap in a weekend. It plugs into your PC ISA bus s just like a sound card or modem. It gives high-resolution timing (microseconds). Because of its programmablity, it is very powerful and flexible. You can even control or DC servo motors using pulse-width modulated (PWM), or Stepper motors using its square wave capabi Platform: |
Size: 5120 |
Author:海应 |
Hits:
Description: formview中显示sheetCodeGuru Migrating Data Between Excel 2000 and SQL Server 2-formview shown sheetCodeGuru Migrating Dat Between a 2000 Excel and SQL Server 2 Platform: |
Size: 1945600 |
Author:gong |
Hits:
Description: C#编写的桌面程序，用于往本地或局域网SQL SERVER数据库导入已定义好模板的Excel表数据，自行配置数据库链接字符串及表名，有非线程式的进度条，后面添加的执行SQL脚本功能未完善，请感兴趣的朋友完善其更丰富的功能，并将其共享，使用小工具，大家共享。-C# Prepared desktop programs for the local area network to local or SQL SERVER databases has been the definition of a good template to import Excel sheet data of its own configuration database link string and table name, a non-linear program of the progress bar, add the implementation of SQL script feature is not perfect, please interested in improving his friends richer functionality, and sharing, the use of small tools, for all to share. Platform: |
Size: 36864 |
Author:zhanjun |
Hits:
Description: 不同数据库的转换 用delphi实现access excel sql server 等数据库的转换-Use different database delphi implementation of the conversion access excel sql server database, such as conversion Platform: |
Size: 605184 |
Author:huankewen |
Hits:
Description: Stok report using excel and crystall report to extract data from sql server (ERP System) and combine it with excel stock Platform: |
Size: 2919424 |
Author:qhoore |
Hits:
Description: 一个相对很完善的数据挖掘系统（少部分功能欠缺），不仅包括了按类Association（内含Apriori，C4.5，GrowTree）,Classification(ID3),Cluster划分常用的算法及个人优化后的算法。同时包含了多种数据源（MS Access，Excel，SQL Server，TEXT）的界面直接连接方式。界面方面更像一个专业的系统，采用了类VC浮动多框架界面，也可以作为界面编程的参考。这个工程的分数和其他小工具的分数一样，感觉亏大了:)-A relatively well-developed data mining system (a small number of features are not available), including not only the per-class Association (containing Apriori, C4.5, GrowTree), Classification (ID3), Cluster algorithm for division of common and individual optimized algorithms. Also includes a variety of data sources (MS Access, Excel, SQL Server, TEXT) means direct connection interface. Interfaces more like a professional system that uses a type of floating multi-frame interface, VC can also be programmed as an interface reference. The project scores and scores of other small tools, like, sensory loss big:) Platform: |
Size: 572416 |
Author:马志强 |
Hits:
Description: 这是《数据挖掘原理与应用—SQL Server 2008数据库》的随书SQL语句、源代码和Excel范例文件，基于DMX，代码主要包括对SQL Server 2008和Excel 2007中已经集成好的数据挖掘算法的应用， 如贝叶斯聚类、决策树、时序、聚类、序列聚类、关联规则、神经网络、逻辑回归、OLAP立方体的等算法，具有极高的使用价值。-This is the " Principles and Applications of data mining-SQL Server 2008 database" SQL statements with the book, the source code and Excel sample file, based on the DMX, the code mainly on the SQL Server 2008 and Excel 2007 have been integrated in the application of good data mining algorithms such as Bayesian clustering, decision tree, time series, clustering, sequence clustering, association rules, neural network, logistic regression, OLAP cubes and other algorithms, with a high use value. Platform: |
Size: 27428864 |
Author:吴 |
Hits:
Description: Labview Sql Toolkit 读研的时候，研究所老师花钱买的 外面下不到 需要的童鞋们有福了-The SQL Toolkit allows users to access and update databases from LabVIEW. LabVIEW interacts with a database through a database driver- the toolkit ships with drivers for many databases such as dBASE and FoxPro. A user is not limited to using the drivers that ship with the SQL Toolkit. For instance, if they already have Excel, they should configure their database to use the Microsoft supplied Excel driver. The SQL Toolkit establishes a database connection based upon information stored in the ODBC Administrator. ODBC is a database standard that specifies connectivity between database vendors. The ODBC Administrator is a Microsoft Utility that ships with the SQL Toolkit. It is also installed with other Microsoft Programs such as Excel or Access. The ODBC Administrator keeps track of databases through their DSN- data source name. Additional connection parameters (user name and password) and database attributes such as file cache size and locking can be specified in the ODBC Administrator a Platform: |
Size: 3339264 |
Author:ganard |
Hits:
Description: sql server 数据库系统，通过excel向sql server导入数据，大学院系专业管理系统-sql server database system, excel to sql server import data, university department, professional management system Platform: |
Size: 1418240 |
Author:frank |
Hits:
Search - excel sql server