B bzmouse Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-03 #1 我现在需将一至几个SQLSERVER表在BCB中导成EXCEL输出,请问 如何操作?最好有例子!谢谢!
H hfghfghfg Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-03 #3 OPENDATASOURCE 不使用链接的服务器名,而提供特殊的连接信息,并将其作为四部分对象名的一部分。 SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:/Finance/account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions 请
OPENDATASOURCE 不使用链接的服务器名,而提供特殊的连接信息,并将其作为四部分对象名的一部分。 SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:/Finance/account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions 请
H hardware007 Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-03 #4 直接用sql语句 然后copy and paste
H hfghfghfg Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-03 #5 insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:/1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[sheet2$] (F1, F2) select sysid, sysname from appsys
insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:/1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[sheet2$] (F1, F2) select sysid, sysname from appsys
J jackyzjh Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-03 #6 EXEC master..xp_cmdshell 'bcp "SELECT * FROM table " queryout E:/boc/DT.xml -c -Sservername -Usa -Ppassword'
EXEC master..xp_cmdshell 'bcp "SELECT * FROM table " queryout E:/boc/DT.xml -c -Sservername -Usa -Ppassword'
迷 迷糊 Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-03 #7 跟别人学的,ado连excel,执行 SELECT * into newtable FROM table1 IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=local;DataBase=yourdb;]
跟别人学的,ado连excel,执行 SELECT * into newtable FROM table1 IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=local;DataBase=yourdb;]