没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
导入到sqlserver中
dbf文件
SELECT * into newtablename
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\";User ID=Admin;Password=;Extended properties=dBase 5.0')...bmk
或select * into newtablename
from openrowset('MICROSOFT.JET.OLEDB.4.0','dBase 5.0;DATABASE=c:\','select * from bmk.dbf')
这样就可以把c:\中的bmk.dbf表导入到Sqlserver中,速度是最快
delphi语句:
ADOQuery1.sql.Add(' SELECT * into newtablename FROM
OpenDataSource( ''Microsoft.Jet.OLEDB.4.0'', ''Data Source=c:\;
User ID=Admin;Password=;Extended properties=DBASE IV'')...dbf文件名');
Txt文件
select * into newtablename from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=c:\temp;','select * from aaaa.txt')
delphi语句:
ADOQuery1.sql.Add(' select * into newtablename from OpenRowset(''MSDASQL'', ''Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=c:\;'',''select * from aaaa.txt'')');
dbf文件
SELECT * into newtablename
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\";User ID=Admin;Password=;Extended properties=dBase 5.0')...bmk
或select * into newtablename
from openrowset('MICROSOFT.JET.OLEDB.4.0','dBase 5.0;DATABASE=c:\','select * from bmk.dbf')
这样就可以把c:\中的bmk.dbf表导入到Sqlserver中,速度是最快
delphi语句:
ADOQuery1.sql.Add(' SELECT * into newtablename FROM
OpenDataSource( ''Microsoft.Jet.OLEDB.4.0'', ''Data Source=c:\;
User ID=Admin;Password=;Extended properties=DBASE IV'')...dbf文件名');
Txt文件
select * into newtablename from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=c:\temp;','select * from aaaa.txt')
delphi语句:
ADOQuery1.sql.Add(' select * into newtablename from OpenRowset(''MSDASQL'', ''Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=c:\;'',''select * from aaaa.txt'')');
Excel文件
SELECT * into newtablename FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="C:\b.xls";Extended Properties="Excel 8.0;HDR=Yes; ";Persist Security Info=False')...sheet1$
delphi语句:
ADOQuery1.sql.Add(' SELECT * into newtablename FROM
OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data Source=C:\aaaa.xls;Extended Properties="Excel 8.0;HDR=Yes;";Persist Security Info=False'')...sheet1$');
Access文件
SELECT * into newtablename FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\db1.mdb;User ID=Admin;Password=;Persist Security Info=False' )...表名
SELECT * into newtablename FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\db1.mdb';'admin';'', 表名或查询语句)
delphi语句:
ADOQuery1.sql.Add('SELECT * into newtablename FROM
OPENDATASOURCE (''Microsoft.Jet.OLEDB.4.0'',''Data Source=C:\db1.mdb;User ID=Admin;Password=;Persist Security Info=False'' )...ylbx');
以上操作可直接在sqlserver查询分析器中直接运行,如在dephi等开发平台上则要创建一个与sqlserver服务器的连接,如:cn ,并且ADOQUERY的连接属性设为cn。
以上操作是将外部数据添加到sqlserver中并生成新表,如果将数据导入到已存在的表时只要将“SELECT * into newtablename FROM “改成“insert into tablename select * from ”即可。
SELECT * into newtablename FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="C:\b.xls";Extended Properties="Excel 8.0;HDR=Yes; ";Persist Security Info=False')...sheet1$
delphi语句:
ADOQuery1.sql.Add(' SELECT * into newtablename FROM
OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data Source=C:\aaaa.xls;Extended Properties="Excel 8.0;HDR=Yes;";Persist Security Info=False'')...sheet1$');
Access文件
SELECT * into newtablename FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\db1.mdb;User ID=Admin;Password=;Persist Security Info=False' )...表名
SELECT * into newtablename FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\db1.mdb';'admin';'', 表名或查询语句)
delphi语句:
ADOQuery1.sql.Add('SELECT * into newtablename FROM
OPENDATASOURCE (''Microsoft.Jet.OLEDB.4.0'',''Data Source=C:\db1.mdb;User ID=Admin;Password=;Persist Security Info=False'' )...ylbx');
以上操作可直接在sqlserver查询分析器中直接运行,如在dephi等开发平台上则要创建一个与sqlserver服务器的连接,如:cn ,并且ADOQUERY的连接属性设为cn。
以上操作是将外部数据添加到sqlserver中并生成新表,如果将数据导入到已存在的表时只要将“SELECT * into newtablename FROM “改成“insert into tablename select * from ”即可。
剩余18页未读,继续阅读
资源评论
菈楓
- 粉丝: 7
- 资源: 80
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功