如何批量从*.TXT，把数据插入表中么？（UP的有分，谢谢，，急急，在线等待）

2003-11-21 02:51:13 101 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Python自动化：3分钟搞定微信收藏链接批量导出到TXT（附完整代码）本文介绍如何使用Python自动化工具在3分钟内将微信收藏链接批量导出到TXT文件。通过模拟人类操作和OCR技术，脚本高效处理大量链接，显著提升工作效率，并附有完整代码和实战避坑指南。阅读详情

数据库中有表如下：
CREATE TABLE [dbo].[Surveys] (
[SurveyID] [int] IDENTITY (1, 1) NOT NULL ,
[SurveyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SurveyInstructions] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SurveyResponse] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

----------------------------------------------------------
--C盘中有一文件Surveys.txt
--内容如下

1,"New Web Site Design","Please complete each question. Thank you!","Thank you for taking the time to answer our questions. Your feedback is greatly appreciated!"
2,"Sales Staff","We want to know what you think about our sales staff.","Thank you for taking the time to answer our questions. Your feedback is greatly appreciated!"

怎样把数据批量插入表中？不是一句句的使用SQL！

...全文

别再只会用555了！手把手教你用运放和RC电路搭一个50Hz正弦波信号源（附Multisim仿真文件）本文详细介绍了如何使用运放LM358和RC电路搭建一个精准的50Hz正弦波信号源，涵盖文氏电桥核心原理、单电源供电解决方案、Multisim仿真及实物调试技巧。通过实战指南和优化建议，帮助电子爱好者快速掌握低频信号生成技术，适用于各种测试和校准场景。阅读详情

youngby

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

zjcxc 元老 2003-11-21

打赏
举报

--上面的有点错,正确的应该是:
CREATE TABLE [dbo].[Surveys] (
[SurveyID] [int] IDENTITY (1, 1) NOT NULL ,
[SurveyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SurveyInstructions] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SurveyResponse] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

set identity_insert Surveys on
insert into Surveys(SurveyID,SurveyName,SurveyInstructions,SurveyResponse)
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=NO;DATABASE=C:\'
,Surveys#txt)

select * from Surveys
go
drop table Surveys

zjcxc 元老 2003-11-21

打赏
举报

insert into surveys
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=NO;DATABASE=C:\'
,a#txt)

txlicenhe 2003-11-21

打赏
举报

http://expert.csdn.net/Expert/topic/2341/2341997.xml?temp=.2739221
SQL语句导入导出大全

/** 导入文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename in c:\DT.txt -c -Sservername -Usa -Ppassword'

/** 导出文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename out c:\DT.txt -c -Sservername -Usa -Ppassword'
或
EXEC master..xp_cmdshell 'bcp "Select * from dbname..tablename" queryout c:\DT.txt -c -Sservername -Usa -Ppassword'

导出到TXT文本，用逗号分开
exec master..xp_cmdshell 'bcp "库名..表名" out "d:\tt.txt" -c -t ,-U sa -P password'

BULK INSERT 库名..表名
FROM 'c:\test.txt'
WITH (
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)

pengdali 2003-11-21

打赏
举报

BULK INSERT Surveys
FROM 'c:\Surveys.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

update Surveys set
surveyname=substring(surveyname,2,len(surveyname)-2),
SurveyInstructions=substring(SurveyInstructions,2,len(SurveyInstructions)-2),
SurveyResponse=substring(SurveyResponse,2,len(SurveyResponse)-2)

select * from Surveys

pengdali 2003-11-21

打赏
举报

BULK INSERT Surveys
FROM 'c:\Surveys.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

如何批量从*.TXT，把数据插入表中么？（UP的有分，谢谢，，急急，在线等待）

相关推荐