Location:
Search - SQL Excel
Search list
Description: 使用SQL将表导出Excel文件
Platform: |
Size: 56320 |
Author: ggzhao |
Hits:
Description: 一个把SQL Server中的表导为Excel中标的例子-On a table in SQL Server Introduction to the successful examples of Excel
Platform: |
Size: 74752 |
Author: 站长 |
Hits:
Description: SQL Server与Access、Excel的数据转换-SQL Server and Access, Excel data conversion
Platform: |
Size: 2048 |
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: VB与EXCEL精华 VB与EXCEL精华-VB and Excel essence of the essence of VB and Excel and VB VB and Excel essence of the essence of VB and Excel Excel cream
Platform: |
Size: 12288 |
Author: jjie |
Hits:
Description: 先将excel文件另存为 txt 文件，用impexp32 导入到 oracle 中.zip-first to excel txt file separate documents, with impexp32 were imported into the oracle. zip
Platform: |
Size: 28672 |
Author: 陈明 |
Hits:
Description: 简要说明:直接通过DAO读、写Access文件
直接利用DAO来创建、读写Access文件，总的说来，对比上篇<直接通过ODBC读、写Excel文件>来讲，要简单一些。在下面的示例中，我们将用到两种方法：SQL和DAO类涵数来混合实现它们，这样做的目地，我想可以使大家更加方便灵活的运用它们来完成你想要做的东西。在示例程序中默认指定创建数据库名为：Demo.mdb，内部表名为：DemoTable，写入两个字段：名字和年龄，采用和上一篇读写Excel类似的操作，你也可以根据自己需要来动态改变它们。
-Brief Description : DAO directly through reading, writing documents directly using Access to create DAO, Access document literacy, in general, compared to the previous chapter
Platform: |
Size: 136192 |
Author: boy5678 |
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: 程序采用多线程序执行SQL语句，另外集成了数据导出功能（生成.txt文件，可用EXCEL以逗号分隔符的形式打开，可以说是一种变相的导出为EXCEL的功能，但不依赖于安装EXCEL才能运行），此程序本是我用来调试SQL语句的，现将其公布给大家使用-procedures for multi-line procedures for the implementation of SQL, Another integration of data derived function (production. txt documents, Excel can be used to comma-delimited in the form of open, It can be said is a covert derived for the Excel function, but is not dependent on the installation of Excel to run), This is the procedure I used to debug SQL statements, and now their published for everyone to use
Platform: |
Size: 754688 |
Author: fasfsf |
Hits:
Description: SQL和ACCESS数据库导出导入TXT、DBF、Excels -SQL and ACCESS database to export into TXT, DBF, Excels
Platform: |
Size: 277504 |
Author: qweqwe |
Hits:
Description: 以SQL语句从数据库里查询出记录，并输出到EXCEL中，这下好了，我们要从数据库里出报表就方便多了，先把数据取出来，再在大家熟悉的EXCEL里下进行后期处理就可以了［注：这是源代码，需要编译］。-SQL statement to query from the database of records, and output to EXCEL, which under the Well, from the database of our statements on the much more convenient, first out data, and then in the U.S. familiar with EXCEL in the late treatment under can be a [Note: This is the source code, the need for the compiler].
Platform: |
Size: 246784 |
Author: 达达 |
Hits:
Description: SQL和ACCESS数据库导出导入功能,ACCESS导出TXT,TXT导入ACCESS,DB导入ACCESS,ACCESS导出至DB,ACCESS导ACCESS,ACCESS导出DBF中,DBF导出ACCESS中,ACCESS导出至EXCEL中,EXCEL导入至ACCESS中.
SQL导出至TXT中,TXT导入至SQL中,SQL导出至EXCEL中,Excel导入至SQL中,SQL导出ACCESS中,ACCESS导入SQL中,SQL导出DB中,DB导入SQL中.-SQL and ACCESS database export import feature, ACCESS Export TXT, TXT import ACCESS, DB import ACCESS, ACCESS Export to DB, ACCESS mediated ACCESS, ACCESS export DBF in, DBF export ACCESS China, ACCESS Export to EXCEL in, EXCEL Introduction Entry to ACCESS in. SQL Export to TXT in, TXT to SQL in the import, SQL Export to EXCEL in, Excel Import to SQL in, SQL Export ACCESS China, ACCESS import SQL in, SQL in DB Export, DB Import SQL in.
Platform: |
Size: 327680 |
Author: poacher |
Hits:
Description: 软件名称：dbfview2000
版本：2.02
原版下载：http://www.dbf2002.com
详细链接：http://www.dbf2002.com/dbfview.exe
运行环境：Windows 95/98/NT/2000/2003/XP
软件性质：共享
汉化软件：HAP-pdbfview-hyy.rar
汉化大小：335K
汉化作者：兰天白云
E-mail：huyy3@tom.com
软件介绍：
1.支持 Clipper/FoxPro/VFP/DB2K DBF文件格式
2.支持超过2GB的DBF文件
3.自动检测数据表和字符集
4.自动关联.DBF文件
5.快速浏览
6.支持通配符查询
7.快速删除重复记录
8.记录浏览方式
9.创建、修改和打印dbf文件结构
10.输出到DBF, TXT, XML, Excel, HTML(以表或表单方式), PRG, SQL文件
11.高级排序:以任何字段排序
12.如果文件允许，自动打开共享方式
13.由DBF, text and Paradox文件输入记录
14.恢复删除的记录
15为每个字段统计信息：最小、最大、平均、求和
16.OEM和ANSI转换
17.格式命令: 大写、小写和首字大写
18.设置编辑权限口令
19.用户自定义字体和颜色-err
Platform: |
Size: 346112 |
Author: ymy |
Hits:
Description: 支持数据excel导入。数据库（ACCESS/SQL）-companies wage Inquiry System v1.1 Web browser to inquiries wage system. Support data into excel. Database (ACCESS / SQL) -Supports data import excel. Database (ACCESS/SQL)-companies wage Inquiry System v1.1 Web browser to inquiries wage system. Support data into excel. Database (ACCESS/SQL)
Platform: |
Size: 619520 |
Author: 王志勇 |
Hits:
Description: excel to sql从excel导入到ms sql server-excel to sql from excel into ms sql server
Platform: |
Size: 1614848 |
Author: jj |
Hits:
Description: EXCEL导数据到SQL,E XCEL导数据到SQL-EXCEL guide data to SQL, E XCEL guide data to SQL
Platform: |
Size: 667648 |
Author: lvhongyue |
Hits:
Description: java 对 Excel 的操作,实现EXCEL与数据库的互换 ,SQL可以自己看程序写出来,这里不提供了-java to Excel operation, realize swaps EXCEL and database, SQL can watch the procedure written here do not provide a
Platform: |
Size: 8400896 |
Author: 黄飞 |
Hits:
Description: 完成从EXCEL文件向SQLSERVER的数据导入和导出，能自动识别数据有效范围，对于用户完全屏蔽EXCEL的启动过程；-DataPopline From SQL Server To Excel File.
Platform: |
Size: 264192 |
Author: 侯杰 |
Hits:
Description: exporter vos données depuis sql server vers excel
Platform: |
Size: 495616 |
Author: alvaro |
Hits:
Description: sql excel 操作 ，实现数据交互，读出和写入(sql excel operation)
Platform: |
Size: 4067328 |
Author: Viola123
|
Hits:
« 12
3
4
5
6
7
8
9
10
...
17
»