前提条件:
execl 2003
sql server 2005
开始:
主程序调用部分:
main.bat
echo on
:begin
set/p a1=请输入用户名并按回车:
set/p a2=请输入第密码并按回车:
sqlcmd -U%a1% -P%a2% -S10.25.10.228 -iE:/upload/elite/abc.sql
abc.sql
--向已存在的表中插入数据
insert into e_offline_message$ SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="E:/upload/elite/ELITE_2010-11-01.xls";User ID=Admin;Password=;Extended properties=Excel 8.0')...e_offline_message$
go
--创建新表并插入数据
insert into e_offline_message$ SELECT * FROM OpenDataSource(
'Microsoft.Jet.OLEDB.4.0','Data
Source="E:/upload/elite/ELITE_2010-11-01.xls";User
ID=Admin;Password=;Extended properties=Excel 8.0')...e_offline_message$
go